| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: Join and Lookup Stage
Answer: If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why |
| February 02, 2008 03:09:23 |
#1 |
| sqlquiz82 |
Member Since: October 2007 Total Comments: 1 |
RE: Join and Lookup Stage
|
if the reference datasets are big enough , use a join. A join does a high-speed sort on the driving and reference datasets.Once the sort is over the join processing is very fast |
| |
Back To Question | |
