Hi,
Lookup() is what kind of join ?

Answer Posted / sunil

Lookup works as Master outer Join in informatica ..

Oracle--> its works as left outer join..

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many steps etl contains explain with example?

479


When do we analyze the tables?

538


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

536


what is the use of server?

1737


Identifying the bottlenecks in various components of Informatica and resolving them.

1504






Explain me ETL project architecture in Detail?

1924


Explain about etl data integration software?

484


What is fact? What are the types of facts?

536


how do u set partition points in the mapping?

2096


Difference between flat files and relational sources?

1770


how do u set partition points in the mapping?

1798


Explain different types of partitioning?

617


What is staging area referring to?

575


what is the meant by Normalization and de-normalization?

2235


what are the production issues in datastage?

9736