Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Why we use source qualifier transformation?

asked marvit September 20, 2014 08:05 AM  

Why we use source qualifier transformation?


1 Answers

answered By Mswami   0  

It is an active transformation which acts like a source for Informatica.


• To convert source data types to Informatica data types.

• To generate SQL query (SELECT query) based on projection of ports.

Perform the below steps:

Step1: Select the source qualifier SQ_EMP in the Mapping Designer.

Step2: In the Transformations menu select the edit option.

Step3: Select the Ports tab in the Edit Transformations window.

Note: The Input and Output ports for the Source Qualifier are disabled (this means the data coming to the input port and going from the output port can’t be modified). Data will just pass through without any transformation.

Step4: Now select the Properties tab.

Note: By default the tracing level is Normal.

 The tracing level is common to all the transformation logics.

Step5: To ways to edit the transformation:

 • Double click the Source qualifier (SQ_EMP)
 • Select the edit option in the Transformation menu.

Step6: Go to the properties tab of the Edit Transformations Window and click on the drop-down button.

Step7: SQL Editor window opens up. Give ODBC data source, username and password and click the Generate SQL button.

Step8: Click on Apply and then OK.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!