Hi All,
I would like to know the best Partitioning Technique for Change Capture Stage.
The preceeding stage is a Sequential File and the target is an ODBC Enterprise stage.
Thanks in advance.
Regards,
Deepa
Partitioning Technique for Change Capture Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Best" does not come into it. You need a key-based partitioning algorithm that causes key adjacency - that is, all records that have the same value in those columns that are identified as Change Key candidates must end up on the same partition.
If the Change Key is a single integer column, then Modulus is preferred, as it is slightly more efficient than Hash. Any other format of Change Keys and you need Hash.
If the Change Key is a single integer column, then Modulus is preferred, as it is slightly more efficient than Hash. Any other format of Change Keys and you need Hash.
Last edited by ray.wurlod on Tue Dec 29, 2009 12:21 am, edited 1 time in total.
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.