Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 8741 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil
Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..
If anything wrong pls let me know...am looking for job..
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
How to update source definition?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is powercenter on grid?
what is index?how it can work in informatica
What does role playing dimension mean?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is workflow? What are the components of workflow manager?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the tasks that source qualifier perform?
How can we use mapping variables in informatica?
What is rank transform?
How you prepared reports for OLAP?
Is there any way to read the ms excel datas directly into informatica?
Partition, what happens if the specified key range is shorter and longer
