sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

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.

Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier.

Filter records when the Informatica Server reads source data. If you include a filter condition, the Informatica Server adds a WHERE clause to the default query.

Specify an outer join rather than the default inner join. If you include a user-defined join, the Informatica Server replaces the join information specified by the metadata in the SQL query.

Specify sorted ports. If you specify a number for sorted ports, the Informatica Server adds an ORDER BY clause to the default SQL query.

Select only distinct values from the source. If you choose Select Distinct, the Informatica Server adds a SELECT DISTINCT statement to the default SQL query.

Create a custom query to issue a special SELECT statement for the Informatica Server to read source data. For example, you might use a custom query to perform aggregate calculations or execute a stored procedure.

Cheers,

Sithu

sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

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.

 

Cheers,

Sithu

Rama Rao B.

• Apr 30th, 2007

 

Source qualifier is also a table, it acts as an intermediator in between source and target metadata. And, it also generates sql, which creating mapping in between source and target metadatas.


Thanks,
Rama Rao

Rksinghpathania

 Profile Answers by Rksinghpathania 

• Jun 27th, 2007

 

Def:- The Transformation which Converts the source(relational or flat) datatype to  Informatica datatype.
      So it works as an intemediator between and source and informatica server.

Tasks performed by qualifier transformation:-
1. Join data originating from the same source database.
2. Filter records when the Informatica Server reads source data.
3. Specify an outer join rather than the default inner join.
4. Specify sorted ports.
5. Select only distinct values from the source.
6. Create a custom query to issue a special SELECT statement for the Informatica Server to read source data.

divakar

• Nov 5th, 2007

 

Source Qualifier Transformation is the beginning of the pipeline of any transformation, the main purpose of this transformation is that it is reading the data from the relational or flat file and is passing the data ie. read into the mapping designed so that the data can be passed into the other transformations

jaber

 Profile Answers by jaber 

• Dec 9th, 2007

 

Source Qualifier is a transformation with every source definiton if the source is Relational Database.
Source Qualifier fires a Select  statement on the source db.
With every Source Definition u will get a source qualifier without Source qualifier u r mapping will be invalid and u cannot define the pipeline to the other instance.


If the source is Cobol then for that source definition u will get a normalizer transormation not the Source Qualifier.

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 21st, 2009

 

It is a transformation which is automatically generated to read the data from source tables into informatica designer.