How to change the name of a sorter transformation?
How to create a new mapping for sorter?
- To create a new mapping for sorter, Please navigate to the Mappings menu in Menu Bar and select the Create.. option. Here, you have to write a unique name for this Mapping and click the OK button. TIP: Please refer Informatica Mapping article to understand the steps involved in creating Mapping.
How to configure sorter transformation in Informatica?
- It means, First data is sorted by the [Sales Amount] in Descending Order and then Second, data will be sorted by the [Freight] in Ascending order. Click OK to finish configuring the Sorter Transformation in Informatica. First, Drag and drop the [Sorter Transformation in Informatica] target definition from Targets folder to the mapping designer.
How to sort data by ascending order and descending order?
- Select the direction, Ascending order (A to Z)or Descending order (Z to A) to which direction the data is to be sorted. Click on Apply and Ok button. To create target definition table, navigate to menu bar | Target designer | target and Import from database. It is very essential that after importing table, generate and execute SQL.
Share this Post: