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

Is it possible to create multiple domains on a single Informatica server?

747


While importing the relational source definition from the database, what are the metadata of source that will be imported?

781


What is a snowflake schema?

563


What is a rank transform?

668


Define the various join types of joiner transformation?

557






complex mapping ur project u r invlve can u explain and give real time example give me ?

1833


What are the differences between joiner transformation and source qualifier transformation?

620


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548


What is the difference between a repository server and a powerhouse?

801


What is rank transformation in informatica

685


What is workflow? What are the components of the workflow manager?

631


Why do we need informatica?

552


What is standalone command task?

700


What is a dimensional model?

578


Tell me about Propagate functions in informatica

520