Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95942 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / mythili
Hi everybody,
Joiner is active transformation whereas lookup is passive
transformation.
Joiner returns only matching records whereas lookup
returns null if there is no match.
In join condition we can give only '=' operator but in
lookup condition !=,>=,<= are all possible.
Joiner will do left outer,right outer,normal,full outer
type of joins whereas lookup will do only left outer join.
| Is This Answer Correct ? | 31 Yes | 9 No |
Post New Answer View All Answers
What is union transformation in informatica?
What all are steps in up gradation of Informatica server?
How many types of sessions are there in informatica.please explain them?
What is session task and command task?
is it possible to index the data in cache of lkp transformation ?
What is the difference between router and filter?
How to join three sources using joiner? Explain though mapping flow.
What will be the approach?
What is the need for an etl tool?
Explain sessions. Explain how batches are used to combine executions?
What is dimensional table? Explain the different dimensions.
What are the performance considerations when working with aggregator transformation?
What is a mapplet/worklet in informatica?
How we can create indexes after completing the load process?
Describe the impact of several join conditions and join order in a joiner transformation?
