What is a diff between joiner and lookup transformation
- 16 Answers
- 90845 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
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the components of Informatica? And what is the purpose of each?
Can we create multiple integration service on single repository?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the different types of repositories created using informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Why do we need informatica?
What is depict expression change?
What is rank transform?
How can you increase the performance in joiner transformation?
what is the Default Source Option For Update Strategy Transformation?
In informatica workflow manager, how many repositories can be created?
What is workflow? What are the components of the workflow manager?
If informatica has its scheduler why using third party scheduler?
What is deployment group?
