Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

501


What is resilience time?

669


How union transformation is used?

600


What is enterprise data warehousing?

621


can we override a native sql query within informatica? Where do we do it?

637






can anyone explain me about retail domain project in informatica?

7447


What is informatica powercenter repository?

723


What is joiner change?

693


What is session task and command task?

658


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1633


How is union transformation utilized?

578


list out all the transformations which use cache?

700


Tell me about MD5 functions in informatica

532


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599


What are the components of workflow manager?

599