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
Partitioning Algorithms (Pros and Cons)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Re: Partitioning Algorithms (Pros and Cons)
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.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
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams