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

version controlling in informatica?

3 Answers  


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


r u done any partitions in ur project?

0 Answers   TCS,


What are the types of caches in lookup? Explain them.

0 Answers  


What is the reusable transformation?

0 Answers  


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,


What is Cognos script editor?

0 Answers   Cognizant,


Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,


What are the tasks that can be performed using sq?

0 Answers  


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


Categories