How to split a single row of record in to two row of output

chulett · Post by **chulett** » Tue Apr 03, 2007 9:59 pm

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.

kumar_s · Post by **kumar_s** » Tue Apr 03, 2007 10:19 pm

Use a larger data set.

You are the man.

Now the result is screwed up.

chulett · Post by **chulett** » Wed Apr 04, 2007 6:54 am

jlock23 · Post by **jlock23** » Wed Apr 04, 2007 8:51 am

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.