What are the diffrences between joiner transformation and
source qualifier transformation?
Answer Posted / 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 View All Answers
When do you use sql override in a lookup transformation?
How union transformation is used?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is native users?
Explain the etl program with few examples.
Explain the scenario which compels informatica server to reject files?
How do you migrate data from one environment to another?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is meant by pre and post session shell command?
Explain the use of aggregator cache file?
Explain the different lookup methods used in informatica?
without table how to come first record only in oracle?
Explain joiner transformation in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Write the prerequisite tasks to achieve the session partition?