Vamsi Krishna.K

• Oct 1st, 2006

 

if you are using tables ot flat files as sources we need to use source qualifier, for cobol sources we use normalizer. Informatica server doesn't recognize source files with out source qualifiers, so we need to use.

If you are using flat files as sources we have to use joiner to join the two sources after source qualifier.

SRAVAN GOPISETTY

• Oct 5th, 2006

 

To improve the performance.Less no of resources increses the performance.

Soaib Ummar

• Oct 14th, 2006

 

I think when we use the SQ and in that join condition at the SQ then the join condition is established at the database level , which enhance the performance by not bringing lot of data in to the transformation. while in case of hetrogineous sources we are bound to use the joinner

Phani

• Feb 16th, 2007

 

This is because performing join at database level is must faster than performing join at session level. So, if source tables r originating from the same database( say relational) prefer join in the source qualifier transformation than for opting joiner transformation.regards,Phani...

vinodh259

 Profile Answers by vinodh259 

• May 11th, 2007

 

who said that we cant use joiner for homogenous sources. but the thing is performace becomes bad if we use joiner transformation after source qualifier.? it is for the fact that for any sources (homo&hetro) we need source qualifier. instead of joing them in source? if we use joiner to join them the performace becomes poor. our main aim is not only to extract transform and load the date we have to consider cost also. cost in the sense of time and memory.