Hi,
Lookup() is what kind of join ?

Answer Posted / hemant

Lookup is used to be a inner join but starting from the
version 9 it is behaving as a left outer join.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about etl data integration software?

482


how do u really know that paging to disk is happening while u are using a lookup transform?

2041


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2057


What is a mapping?

558


where we cannot use sorter Transformation. if we use then we will not get correct data?

1797






What are the modules in Power Mart?

527


how would u estimate the size of Aggregator transform data and index cache?

1508


What is etl process? How many steps etl contains?

590


What is etl process?

530


Explain different types of partitioning?

616


Explain about round-robi?

621


What is the difference between round-robin partitioning and hash partitioning?

542


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1728


how to load the data to fact table?

2147


What is a materialized view log?

549