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
- 9631 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 is Partitioning ? where we can use Partition?
What are the advantages of informatica?
Explain the etl program with few examples.
What is power center repository?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is curr val use for in sequence generator?
difference between stop and abort
What differs when we choose the sorted input for aggregator transformation?
What is a predefined event?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
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
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
Teradata 
