Hi,
Lookup() is what kind of join ?

Answer Posted / ashish

Lookup by default perform normal join but if you want to achieve left outer ,right outer , full outer join . you can do so by SQL override in lookup

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the etl testing operations includes?

580


Can u access a repository created in previous version of Informatica?

1466


How many types of transformations supported by sorted input?

685


list and discuss two approaches for updation of target table in Informatica and how they are different.

1729


How etl testing is different from database testing?

519






State the differences between shortcut and reusable transformation

513


What is data modeling and data mining?

554


Explain and compare etl & manual development?

521


what is an ETL or ETT? And what are the different types?

6922


how do u identify the changed records in operational data?

2133


flat filevalidation in informatica

1741


Explain etl?

572


What are your responsibilities as an etl tester?

621


Compare etl & elt?

552


What are dimensions?

573