which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 10121 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 78swapnil
All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 is different between the data warehouse and data mart?
How do you use reject loader.
How can we create index after completion of load process?
What are the different ways to implement parallel processing in informatica?
What is blocking transformation?
Did u used latest transformations of 8.6.0? for what?
Differentiate between sessions and batches?
What are the different types of olap? Give an example?
What are pre and post-session shell commands?
What is pmcmd command?
What is decode in informatica?
how many types of dimensions are available in informatica?
Which version configuration tool used in ur project?
Name the different lookup cache(s)?
