Answer Detail: RE: Which partition we have to use for Aggregate Stage in parallel jobs ?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: Which partition we have to use for Aggregate Stage in parallel jobs ?

February 02, 2008 04:53:08	#4
swapnilverma	Member Since: February 2008 Total Comments: 2
RE: Which partition we have to use for Aggregate Stage in parallel jobs ?
Its always preferable & appropriate that we must use a sort stage beore aggregate stage. Hence based on the aggregate logic we should sort the incoming data by using hash partintion on keys. Then we can use same partition on Aggregate stage. This is most commonly used.