Lookup by default perform normal join but if you want to achieve left

Hi,
Lookup() is what kind of join ?

Question Posted / ashish

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

Please Help Members By Posting Answers For Below Questions

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2135

Explain me ETL project architecture in Detail?

2411

What is etl tool in hadoop?

948

Define slowly changing dimensions (SCD)?

1098

can be used COM component in Informatica ?

2111

what happens if the info.server doesn't find the session parameter in the parameter file?

1998

what is different between sequential batch and concurrent batch and which is recommended and why?

4972

What are various etl tools in the market?

1079

how do u implement configuration management in Informatica?

4839

Is hadoop a etl tool?

1002

Two default user groups created in the repository are____and_____.

2106

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4173

Explain about round-robi?

1206

What is etl process. How many steps etl contains explain with example?

1001

What are the types of Data Warehouse applications?

1080