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
Dataset sort order not working
Moderators: chulett, rschirm, roy
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.
Regards,
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 /
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.