What is a diff between joiner and lookup transformation
Answer Posted / sweta kedia
. 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 ? | 34 Yes | 3 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
What are the different types of olap? Give an example?
Explain the pipeline partition with real time example?
Explain what is informatica metadata and where is it stored?
Why do we need informatica?
EXL informatica Questions
What are the different ways to implement parallel processing in informatica?
What is sequence generator transformation in informatica?
What is blocking transformation?
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
What is primary and backup node?
What is status code in informatica?
What is domain in terms of informatica?
What are some examples of informatica etl programs?
What is the status code in stored procedure transformation?