Hash & Auto partition

ankita · Post by **ankita** » Tue May 08, 2007 12:28 pm

Hi,
Can anyone help me to understand how DataStage handles partitions in below cases ?

1> 1st Lookup input is hash partitioned, reference is entire, next lookup stage input is Auto partitioned.Does DataStage change the partition ?
what's the default behaviour of Auto ?

2> Remove duplicate is done using hashed, sorted input .Next Transformer is auto paritioned followed by dataset.Is the dataset still hashed partitioned as in Remove duplicate ?

Thanks in advance !
Ankita

ray.wurlod · Post by **ray.wurlod** » Tue May 08, 2007 5:01 pm

You can tell from the score what partitioning algorithm is used. Generally, unless there are overriding requirements (such as DB2 stage), Auto will use Same on a parallel-parallel link.