Dataset sort order not working

mandyli · Post by **mandyli** » Tue Jan 24, 2012 2:07 pm

Hi

My job1 creating Dataset with sort.

Job2 read the data from the Job1 Dataset . when I view the data it is not showing sorted order due to this my Change Capture stage will not give proper result.

Is there any issue with Datastage on V8.1 or I have to use sort stage before CC stage.

Thanks
Man

srds2 · Post by **srds2** » Tue Jan 24, 2012 3:37 pm

Do a Hash partition and sort on input links before sending the data to Change Capture stage

jwiles · Post by **jwiles** » Tue Jan 24, 2012 9:53 pm

How many rows are you viewing per partition, and are you viewing all partitions or just one?
Have you actually run your job to see if the results are correct?

View Data will show N rows from one partition, followed by N rows from the next partition, and so on until data from all partitions is shown. N is the number of rows selected in the View Data window. It can appear that your data isn't correct if you don't know how it is being shown to you.

Code: Select all

1  \
3  |
5  | Partition 1
7  |
9  /
2  \
4  |
6  | Partition 2
8  |
10 /

Regards,