| |
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 |
| April 04, 2008 14:34:50 |
#2 |
| ramu_open |
Member Since: April 2008 Total Comments: 1 |
RE: Join and Lookup Stage
|
join has no reject links. wheras lookup has one reject link
join has 4 types inner outer,left outer,rght outer. l0ok up gives inner and left outer
lokk up takes any kind of colmn names and perform join operations.join needs same coloumn names among all sources.
if refernce table has little data prefer to lookup more means prefer join.. |
| |
Back To Question | |
