Auto partition in sort stage with a key

sharmabhavesh · Post by **sharmabhavesh** » Mon Oct 05, 2015 11:01 pm

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.

prasson_ibm · Post by **prasson_ibm** » Tue Oct 06, 2015 12:59 am

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.

priyadarshikunal · Post by **priyadarshikunal** » Wed Oct 07, 2015 1:23 am

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