| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: Lookup Stage Partitioning
Answer: With a Lookup stage the input stage has 1million records and reference link has 1million records. What is the best Partition method and why? |
| March 03, 2009 21:27:41 |
#3 |
| gopalanrr |
Member Since: March 2009 Total Comments: 1 |
RE: Lookup Stage Partitioning
|
When the reference link is too high in terms of records fetched, you should be performing a join instead of performing a lookup |
| |
Back To Question | |
