What is a diff between joiner and lookup transformation
Answer Posted / swathi naik
I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
difference between repository database and repository service?
Write the unconnected lookup syntax and how to return more than one column.
what is degenerated dimension?
How to implement security measures using repository manager?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Which transformation is needed while using the Cobol sources as source definitions?
What is meant by lookup transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
can we override a native sql query within informatica? Where do we do it? How do we do it?
permutations of mapplet
Explain the informatica workflow?
What is pmcmd command?
In development project what is the process to follow for an etl developer from day1
How to update source definition?
What are the measure objects?