Functionality of Preserve Partition

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudarsan
Participant
Posts: 31
Joined: Fri Nov 17, 2006 4:14 am

Functionality of Preserve Partition

Post by sudarsan »

Hay, request your help on the below question. Thanks!

Functionality of Preserve Partition SET is equivalent to explicitly specifying SAME partitioning. If I put Preserve Partition as SET in any upstream stage ex(Transformer, Join stage ), the downstream stages will use the SET partition of upstream or I can choose my partition on one stage and using SAME partition in the downstream stages.

What exactly would be the difference and which Scenario SET is advantageous over SAME. Which one is advisable using a preserve partition flag in the upstream or Same partition in downstream. Any specific scenario where Preserve partition is advantageous over Same? If both are same, What is the reason for IBM to create SET and SAME.
Thank You,
Sudarsan AVS
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

They're not the same. One recent discussion is here:

viewtopic.php?t=151955
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply