Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96369 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / sweta kedia
. 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 ? | 34 Yes | 3 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
my source is junk data how will u remove that junk data by using unix please any one replay me
what is the -ve test case in your project.
Which are the different editions of informatica powercenter that are available?
What are the types of data warehouses?
State the differences between sql override and lookup override?
I have a flat file, want to reverse the contents of the flat file
What are the prerequisite tasks to achieve the session partition?
What is Session and Batches?
How you prepared reports for OLAP?
How do you load only null records into target? Explain through mapping flow.
What is rank transformation?
How can you generate reports in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
