Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96370 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the static cache and dynamic cache in informatica?
Explain the features of connected and unconnected lookup.
Define the various join types of joiner transformation?
What is the use of an aggregator cache file?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
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
Sequence generator, when you move from develoment to production how will you reset
Can we create two repositories on same database instance in oracle?
What is informatica powercenter repository?
What all are steps in up gradation of Informatica server?
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 do you use reject loader.
