Sorter transformation is an active and Connected transformation in IICS.Sorter Transformation is used to sort the data based on incoming fields either In Ascending or Descending order.
Procedure;
- Open SQL Developer and check the source table SRC_EMP_DETAILS1 by giving the select statement.
- Login to IICS and Click on new mapping.
- Click on create to create new mapping and rename the mapping of your choice For example: m_sorter.
- In the properties go to source and configure the connections by selecting the required connection name.
- In the object select the source object and click on ok.
- In the source properties click on Preview to preview the data.
- Drag the Sorter transformation from the left side of design menu and select the transformation.
- Rename the sorter transformation.
- Click on the sort option give the required sort condition as it will sort the data based on the condition.
- Click on the Target rename the target and in the properties click on the target and configure the target connections.
-
- Click on the Target rename the target and in the properties click on the target and configure the target connections.
- To create the target at run time click on select and select the target object create new at run time and give the target table name and click on ok.
- Click on save to save the mapping.
- Click on new to create the mapping task and give the proper task name and specify the Run time environment.
.
- Click on select and select the mapping from the mapping list as shown below.
- Click on next and click on Finish.
- Click on Run to run the mapping Task.
- Go to My jobs and check the status.
Check the output in oracle SQL developer HR database
- Here we can see all the records of EMP_SALARY in ascending order are loaded to the target table.