DSXchange

Hi,

With Datastage server (not PX), I would like to use the link partitioner to improve the performance of some of my jobs. I know that there are 4 Partitioning algorithms available for Link Partitioner (Round Robin, Random, Hash, Modulus). I will be thankful if someone tell me what are the pros and cons of each algorithm and what are the criterias that should guide our algorithm selection.

Thanks a lot

Mohamed

lacabessa wrote:Hi,

With Datastage server (not PX), I would like to use the link partitioner to improve the performance of some of my jobs. I know that there are 4 Partitioning algorithms available for Link Partitioner (Round Robin, Random, Hash, Modulus). I will be thankful if someone tell me what are the pros and cons of each algorithm and what are the criterias that should guide our algorithm selection.

Thanks a lot

Mohamed

We are using Round Robin. I played around with the various options ant they seemed to make no difference in the performance of the job.

Round robin is the default algorithm. For more infomation check the manual servjdev.pdf (Page 13-3)

Thanks
Rasi