DSXchange

Hi,
I am sorting some data in the sort stage and creating a key change column. My doubt is 'does Datastage partitions data as well when it has to sort data?'
I mean, if I sorted the data based on a primary key and mention the partition mode as 'auto', will Datastage automatically hash partition data as well based on the key.

Partitioning and sorting go hand in hand or they can take place exclusively.

Hi,

does Datastage partitions data as well when it has to sort data?

Yes, datastage parallel sort stage implicitly places hash partition on input of the sort stage and hence auto partition will perform Hash partition.

It will partition the data if you have auto partition and APT_NO_PART_INSERTION environment variable is not set.