informix-datastage@oliver.com

[admin]

Greetings,

I need to transform an input sequential file that has monthly amounts in comma, delimited format (likely a rolling 18 month maximum) to output records that will contain a single months data. So that 1 input record will generate 18 output records. The date (mm/yyyy) for each month will be found in a column header line at the beginning of the file and will be included on each fact record. Is there a good way to do this?

Any help would be appreciated. By the way, Im using DS 4.0 on a Sun/Solaris server. Thanks, Bob