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
Hash & Auto partition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.