Source Qualifier Transformation - Sort

Source Qualifier Transformation - Sort:

Using Source Qualifier Transformation,

You can Sort the rows of the source by specifying the number of ports.

The Intergration Service adds a ORDER BY clause to the default SQL query.

Note: The Order of the column in the Source Qualifier Transformation should be order of number of ports which we specify for Sort Port.

Edit Source Qualifier Transformation - No of sorted ports

Mappng Designer

This works based on the below query:

select * from employees e,departments d where e.department_id=d.department_id and d.department_name='IT' ORDER BY first_name;

Left Outer Join SQL Query - HR Schema

In the Workflow Manager, the session properties check the Number of sorted ports Properties of Souce Qualifier Properties in the Mapping Tab.

Workflow Manager -Edit Task - Mapping Properties - SQ Properties