Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95952 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
Enlist the tasks for which source qualifier transformation is used.
What is native users?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain how many types of dimensions are available in informatica?
What is a connected transformation?
What is a joiner transformation and why it is an active one?
How do you load only null records into target? Explain through mapping flow.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
lookup transformation with screenshots
Global and Local shortcuts. Advantages.
can anyone suggest best free Talend data integration training online
How to improve the performance of a session using sorter transformation?
What is the use of transformation?
what is mean by complex business rule ?
How to partition the Session?
