Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95266 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
Can anyone tell me the new features in Informatica 9 Version?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Briefly define reusable transformation?
How can we store previous session logs?
design of staging area?
Why update strategy and union transformations are active?
Explain what are the different versions of informatica?
What are the tuning techniques you applied during your last project
How many ways are there to create ports?
How to delete duplicate row using informatica?
What is the maplet?
How to create or import flat file definition in to the warehouse designer?
Why sorter is an active transformation?
How can repository reports be accessed without sql or other transformations?
What is the function of union transformation?
