Interested to Buy Any Domain ? << Click Here >> for more details...
What are the diffrences between joiner transformation and
source qualifier transformation?
- 2 Answers
- 17331 Views
- I also Faced
- E-Mail Answers
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 |
Why we select the table which has minimum number of records as Master table in joiner?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
how may sources can be used in a mapping at a time?(limit)
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
Can we create a node as a gateway node and the same node can be assigned to a grid?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is data merging, data cleansing and sampling?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
How do you manage the Parameter files while migrating your data from one environment to another environment?
In a table, 4 person having same salary. How to get Third person record only?
Teradata 
