Source Qualifier Transformation - Filter

Source Qualifier Transformation - Filter:

Using Source Qualifier Transformation,

You can filter the rows of the source database by adding a where clause in the Source Filter in the Properties Tab of the Edit Transformation.

The Intergration Service adds a WHERE clause to the default query.

Edit Transformations - Properties Tab - Source Filter

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';

Left Outer Join SQL Query - HR Schema

In the Workflow Manager, the session properties check the Source Filter Properties of Souce Qualifier Properties in the Mapping Tab.

Workflow Manager - Edit Task - Mapping Tab - SQ Properties - Source Filter