What is a diff between joiner and lookup transformation
- 16 Answers
- 90752 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 do you understand by a term domain?
What are the differences between oltp and olap?
What is sorter transformation?
How is union transformation utilized?
Please let me know how to make Data masking in informatica..
where to store informatica rejected data?
As union transformation gives UNION ALL output, how you will get the UNION output?
Scheduling properties,whats the default (sequential)
What is option by which we can run all the sessions in a batch simultaneously?
How are the sources and targets definitions imported in informatica designer?
Which are the different editions of informatica powercenter that are available?
What is meant by query override?
How to extract the informatica rejected data?
Enlist the tasks for which source qualifier transformation is used.
How many ways are there to create ports?
