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.
Auto partition in sort stage with a key
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Tue Jun 19, 2012 11:03 pm
- Location: India
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI