Source Qualifier Transformation in Informatica
Source Qualifier Transformations is an Active Transformation, which means it changes the number of rows which are passed through it and it always connected. whenever we add a relational source or a flat file to a mapping a Source Qualifier Transformation comes automatically for every source except for XML and COBOL file. Using SQ Transformation, we can define and override how the data is fetched from the Source.
The Source qualifier represents the rules that the Integration service reads when it runs a particular session from that particular source. Source Qualifier Transformation is the only transformation which cannot be made as a reusable transformation in Informatica.
Explaining Source Qualifier Transformation with example.
In this Informatica tutorial, we shall learn how to create Source Qualifier transformation and write a query to extract employee commission percentage which are not null. In the following example, we will create SQ transformation using Source (EMPLOYEES) and Target (TARGET_EMPLOYEES) in our mapping (M_Source_Qualifier).
Double click on the Source Qualifier to edit SQ Transformation.
Navigate to properties tab and we can see different properties like SQL query, User Defined Join, number of Sorted Ports, tracing Level, select Distinct, Pre SQL, Post SQL, Output is deterministic, output is repeatable.
SQL Query is an SQL override used to put an additional filter on the normal selection. Click on the SQL Query modify option as shown below.
A new window will be opened and here we see ports and built in variable.
When we click on Generate SQL, it generates a query by selecting all the attributes of the source table.
In Source Qualifier Transformation, we can also sort import records based on the port numbers. When a data is passed on to the transformation inside the mapping into the port number, it will read the port number and sort according to it.
- Now save the mapping
Inforamatica user’s need to create workflow and run the workflow.
Output : Source Qualifier transformation
