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 |
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
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?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the reusable transforamtions?
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
How to implement security measures using repository manager?
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?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the function of aggregator transformation?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
What is the use of code page?