DSXchange

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

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

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

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