Row out of sequence
Posted: Mon May 31, 2004 12:22 pm
I have met this error in AGGREGATOR Stage twice in different cases:
First time I set the Sort Columns in Input Link and it ran OK. But Second
time ran another loading (a little bit small file than first time), the error occurred again. After removed the Sort setting, it ran OK.
The question is:
The first file (a big file) loading needs column being sorted and
The second file (a small file) Loading doesn't need column being sorted.
Why does this happen?
How to handle this problem?
My DataStage version is 5.2
Appreciate for any suggestions.
First time I set the Sort Columns in Input Link and it ran OK. But Second
time ran another loading (a little bit small file than first time), the error occurred again. After removed the Sort setting, it ran OK.
The question is:
The first file (a big file) loading needs column being sorted and
The second file (a small file) Loading doesn't need column being sorted.
Why does this happen?
How to handle this problem?
My DataStage version is 5.2
Appreciate for any suggestions.