What are the diffrences between joiner transformation and
source qualifier transformation?

Answers were Sorted based on User's Feedback



What are the diffrences between joiner transformation and source qualifier transformation?..

Answer / swetha

yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.

Is This Answer Correct ?    13 Yes 0 No

What are the diffrences between joiner transformation and source qualifier transformation?..

Answer / david

One important thing is

IN source Qualifier 1)the columns used in the condition must
have primary-key and foreign-key relationship(Compulsory)
For example
If the condition is
Emp.deptno = dept.deptno1
The depeno and deptno1 should have primary and foreign
key relation

2)The datatypes of the couumns must be same

Is This Answer Correct ?    11 Yes 1 No

Post New Answer

More Informatica Interview Questions

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


What are the tasks that Loadmanger process will do?

1 Answers  


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  


What are the reusable transforamtions?

2 Answers  


How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  


How to implement security measures using repository manager?

0 Answers  


I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  


What is the function of aggregator transformation?

0 Answers  


i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,


What is the use of code page?

0 Answers  


Categories