Partitioning Technique for Change Capture Stage

deepa_shenoy · Post by **deepa_shenoy** » Tue Dec 29, 2009 12:05 am

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

nani0907 · Post by **nani0907** » Tue Dec 29, 2009 12:14 am

it would be the hash partioning based on the keys .Try this

ray.wurlod · Post by **ray.wurlod** » Tue Dec 29, 2009 12:15 am

"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.

nani0907 · Post by **nani0907** » Tue Dec 29, 2009 12:18 am

it would be the hash partioning based on the keys .Try this