Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
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 |
How informatica process data means how informatica works?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
Do you have knowledge in ralph kimball methodology
What are the main features of Oracle 8i with context to datawarehouse?
What is a dimensional model?
explain abt union t/r?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
What are the differences between a connected lookup and unconnected lookup?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
explain abt joiner t/r?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What are the diffrences between joiner transformation and source qualifier transformation?