| |
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 13:22:09 |
#1 |
| rajivkumar23us |
Member Since: March 2009 Total Comments: 1 |
RE: Lookup Stage Partitioning
|
Entire Partition.
1 Million rows aren't much to handle for DS engine, since Lookup Stage requires key columns to be in the same partition, with million rows from each side, Entire Partition can be used.
Correct me if I am wrong. |
| |
Back To Question | |
