Answer Detail: RE: Lookup Stage Partitioning

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?

October 10, 2009 11:11:34	#4
Kumar Shourav	Member Since: October 2009 Total Comments: 1
RE: Lookup Stage Partitioning
Better to use JOIN or MERGE stage in place of Lookup. If input data is low in compare to reference data then Lookup is recommendable. Assumption is 1:100 or more.

Back To Question