Informatica Interview Questions on Source Qualifier Transformation

1. What is a source qualifier transformation?

A source qualifier represents the rows that the integration service reads when it runs a session. Source qualifier is an active transformation.

2. Why you need a source qualifier transformation?

The source qualifier transformation converts the source data types into informatica native data types.

3. What are the different tasks a source qualifier can do?

• Join two or more tables originating from the same source (homogeneous sources) database.
• Filter the rows.
• Sort the data
• Selecting distinct values from the source
• Create custom query
• Specify a pre-sql and post-sql

4. What is the default join in source qualifier transformation?

The source qualifier transformation joins the tables based on the primary key-foreign key relationship.

5. How to create a custom join in source qualifier transformation?

When there is no primary key-foreign key relationship between the tables, you can specify a custom join using the 'user-defined join' option in the properties tab of source qualifier.

6. How to join heterogeneous sources and flat files?

Use joiner transformation to join heterogeneous sources and flat files

7. How do you configure a source qualifier transformation?

• SQL Query
• User-Defined Join
• Source Filter
• Number of Sorted Ports
• Select Distinct
• Pre-SQL
• Post-SQL