Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95943 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
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
What is meant by active and passive transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain how to import oracle sequence into informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What can we do to improve the performance of informatica aggregator transformation?
Separate from a database, an information bazaar, and an information stockroom?
What are the types of caches in lookup? Explain them.
Could you explain what is enterprise data warehouse?
Mention few advantages of router transformation over filter transformation.
How can we handle two sessions in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the scenario which compels informatica server to reject files?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the use of target designer?
What are the different versions of informatica?
