| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: What is the exact difference betwwen Join,Merge and Lookup Stage??
|
| May 05, 2008 06:29:47 |
#9 |
| madhava1238 |
Member Since: May 2008 Total Comments: 7 |
RE: What is the exact difference betwwen Join,Merge and Lookup Stage??
|
data selection is very easy in join
dataselection is difficult in merge
join does'nt support reject links
merge support reject links
join supports only 2 files or 2 databases
merge supports
no.of inputs
so finally performance wise join is better than merge.
lookup is used just for comparison purpose |
| |
Back To Question | |
