Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 9846 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / zak
Yes, we can use Lookup to join 2 tables. Lookup performs
Left Outer Join by default.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
What are the types of maping in Getting Started Wizard?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How will u pas the data with out debugger?
How to delete duplicate row using informatica?
what is datamart
What is fact table? Explain the different kinds of facts.
disable caching in a lookup transformation?
how to through logic of informatica using the push down optimization into oracle.
What is the meaning of decode in informatica?
What is the difference between a connected look up and unconnected lookup?
How do you take care of security using a repository manager
Teradata 
