Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95245 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
How can we create index after completion of load process?
Explain scd type 3 through mapping.
What is the Rank index port in Rank transformation?
What is the function of aggregator transformation?
How can we store previous session logs?
What is an Integration service in Informatica?
What is different between the data warehouse and data mart?
What is a node in Informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the types of schemas we have in data warehouse and what are the difference between them?
What is transformation?
