Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 9573 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 |
Differences between connected and unconnected lookup?
Write the program through which the records can be updated?
What is intricate mapping?
What is the difference between writing a joiner query in ANSI style and THETA style?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
How many repositories can we create in Informatica?
What is difference between maplet and reusable transformation?
What is a joiner transformation and why it is an active one?
can anyone explain me about sales project in informatica?
What is rank transformation in informatica
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Teradata 
