When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier represents the rows that the Informatica Server reads when it executes a session.
Source Qualifier is an default transformation in informatica. It fires a SQL query against your source database.  Even we can View the query in Properties tab.
Source qualifier transformation, not only extracts the data from the source definition, but also combines the two or more souce defintions (same database), apply the user defined joiner condition for reject the unwanted data as early as possible.
This is the base transformation. You cannot opertae directly on Source, so Informatica provide this transformation and the basic ETL(Extraction Transformation Loading) logic starts from Source Qualifier.
Source qualifier is the recordeset (select statement ) for the source data.Source definition is the structure of the source but the data is kept on source qualifier as a buffer. cheers, Rashmi 9916631010
source qualifier is used to convert the source data type to Informatica readable format.
we can do mapping without source qualifier..in that case the datatypes of the source columns should be same as what will be mentioned in source qualifier..
Source Qualifier Is the default Transformation. Through The source Qualifier Transformation Informatica Reads The Data. We can Filter The Data. We can sort the Data. Its also Used to Join Homogeneous Source systems. We can Join Any number of Sources in Singlae Source Qualifier. We Can't Join the Flatfiles In sourcequalifier Because Flatfiles Are Heterogeneous When we open the Flatfiles At sourcequalifier At the time All The options are Disabled.
