What are the diffrences between joiner transformation and
source qualifier transformation?
Answers were Sorted based on User's Feedback
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 |
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 |
What is the Rank index port in Rank transformation?
How many ways a relational source definition can be updated and what are they?
What is router transformation
how will you remove the duplicate records from flat file without using sorter?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
in which situations do u go for sequence generator ?
How to extract sap data using informatica?
what is scd?
How do you implement unconn. Stored proc. In a mapping?
Why we select the table which has minimum number of records as Master table in joiner?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
explain abt joiner t/r?