DSXchange

Craig and Ken,
Thank you for the information.
Anoop

I have a transformer stage in a server job that writes 2 output files Edited output and an Error file. The record should be written to the Error file based on 3 different constaints. I want to write different error messages for each field that cause the reject. I tried using 3 different reject links...

How do I concatenate the files from mutiple jobs and feed it to a single job?

I was using a link collector to do the same. Is there an alternate method?

Thank you Ken !

I have multiple server jobs (Eg: J1a,J1b,J1c) that creates sequential output files with the same format. At the end of all those jobs I need to combine all the outfiles from those jobs and load it to a database using one job (J2a). In my case, in certain situtation, some of the initial jobs will not...

I have reviewed the Pivot stage, and what I am trying to do here is vertical pivot (Rows to columns), that is not supported by this stage.

Thank you Ray, logic. I will refer to the Pivot stage.

logic wrote:Arn73,
The following post might help you to proceed.
viewtopic.php?t=96215&highlight=

It appear to be slightly different. I have the output file where the columns are the second part of the input file key. Also, the number of columns in the output is fixed.

I am a new user of Datastage. I am trying to convert one sequential file to another, where the rows in the input will be columns in the output. Input: (Key-ID+Qtr) ID;Qtr;Qty 1112;Q1;10 1112;Q2;87 1112;Q3;874 1112;Q4;91 1134;Q1;40 1134;Q3;43 Output: (Key-ID) ID;Q1QTy;Q2Qty;Q3Qty;Q4Qty 1112;10;87;874...