Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95283 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
What is meant by LDAP users?
Describe expression transformation?
can u give example for factless fact table
How can informatica be used for an organization?
What are the differences between a connected lookup and unconnected lookup?
Implementation methodology
What is the surrogate key?
Why sorter is an active transformation?
What is persistent lookup cache?
Explain the use of aggregator cache file?
What are the components of the workflow manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is transformation?
Can we override a native sql query within informatica?
What is the sql query overwrite in source qualifier in informatica
