Partitioning
Posted: Sat May 14, 2005 1:39 pm
Hi ,
In my DDL , I've got 4 columns as the primary key of the columns and for all the join stage I'm using the "Hash" partitioning , is this the right approach or I should go for Auto. I've got the impression that when we say "Auto" datastage uses the "round robin" or "entire" partitioning internalley depending on the previos stages and the preserve partitioning flag, as per my requirement I shdn't be going for either of them so I'm using "Hash". Just wondering is this correct approach?
Thanks in advance.
In my DDL , I've got 4 columns as the primary key of the columns and for all the join stage I'm using the "Hash" partitioning , is this the right approach or I should go for Auto. I've got the impression that when we say "Auto" datastage uses the "round robin" or "entire" partitioning internalley depending on the previos stages and the preserve partitioning flag, as per my requirement I shdn't be going for either of them so I'm using "Hash". Just wondering is this correct approach?
Thanks in advance.