DSXchange

You got lucky.

Sequential files are by their nature multiple read but single write operations. This is not a 'DataStage thing'. More than likely you won't get any kind of error but the output would be... unpredictable... at best. Junk at worst case.

Use a larger data set. Run the job more than once. Unless you ensure that only one process is writing to the file at any given time - you will have problems.

Use a larger data set.

You are the man. Now the result is screwed up.

I agree with a previous poster. Use the Pivot stage. That's what it is designed to do (take one row and split it into mutiple rows). Much cleaner than the transformer split and sequential file merge option.