shanthi1

 Profile Answers by shanthi1 

• Apr 24th, 2007

 

There is no SQL override in FILTER where as in Source Qualifier we have SQL override ,and also in SQ transformation we have options like SELECT DISTINCT,JOIN,FILTER CONDITIONS,SORTED PORTS etc...

ramgan_tryst

 Profile Answers by ramgan_tryst 

• May 15th, 2007

 

In Source Qualifier we can filter records from different source systems(Relational or Flatfile). In Filter Transformation we will filter those records which we need to update or proceed further. In simple before Filter Transformation the data from source system may or may not be processed(ExpressionTransformation, etc...).

g.nagaprasad

 Profile Answers by g.nagaprasad Questions by g.nagaprasad

• May 21st, 2007

 

By using source qualifier transfomation we  can filter out the records for only relational sources but by using Filter Transformation we can filter out the records of any source..

Sujaya

• Sep 3rd, 2007

 

By using Source Qualifier we can filter out records from only relational sources. But by using Filter Transformation we can filter out records from any sources.

In Filter Transformation we can use any expression to prepare filter condition which evaluates to TRUE or FALSE. The same cannot be done using Source Qualifier.

divakar

• Nov 5th, 2007

 

A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted  from this  transformation after connecting to the  source data base.

A filter transformation is a transformation which is placed in the mapping pipe line in order to pass the data to the data following some specific conditions that has to be followed by the passing records.

Of course the same purpose can be solved by the Source Qualifier transformation if this is extracting data from a relational source, where as if the data is going to be extracted from a flat file then we cannot do it using source qualifier.

manoj_behera82

 Profile Answers by manoj_behera82 

• Nov 9th, 2009

 

Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well.
It is capable of doing a
filtration of records based on the condition we provide in the SQL override.
We can have a number of tables (from homogenous sources) joined inside the
SQL override of a source qualifier.
It is used in the very early stage of the mapping.
vs
Filter is a transformation that is used after source qualifier (even if it is brought at the earliest in the mapping).
It can filter out records based on a condition we provide.

We should try to reduce the number of records into the mapping by filtering them out in the source qualifier itself.
We should try to use a filter only when there is no way out.
As a practice we should use as less transformation as possible.