Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?
- 2 Answers
- 8684 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 |
How can you define a transformation? What are different types of transformations in Informatica?
how can one come to know wether the records loak into the target if we use update strategy
In a concurrent batch if a session fails, can you start again from that session
What is the procedure for creating independent data marts from informatica 7.1?
How can i send first half of the records to one target and Remaining to other target?
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?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
What is different between informatica version 8 and 9 version
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
Hi All can anyone tell me where i will get Informatica training in Mumbai?
How to extract sap data using informatica?
Teradata 
