DSXchange

@FranklinE -

I am not using the CFF to read the source file because there is no delimiter in the source file.
(Besides the header/trailer)
Each record is 400 chars
Header/Trailer are 70 chars

Does this help?
Thank you for the post.

Jared

Hello All, Currently, I am provided with a fixed flat file. The flat file has a header and trailer record. The records which are not the header/trailer need to be packed in the CFF Stage. - Job design: Seq. File -> Transformer -> Sort -> CFF - The records are brought in as one column 'A' varchar 100...

ShaneMuir:

The source is a sequential file.

qt_ky:

I want to retain(keep) the records and route them to their own stage.

chulett & ray.wurlod: thank you for your post. I will test the fork join and reply.

Hello,

Is there a way I can retain both duplicates from a stage in DataStage?
The primary key is column 1.

Ex.

Column1|Column2|Column3

111|EA|203
111|EA|201
112|EA|200
113|EA|200

I want to remove both records where column 1 = 111.

Please advise.

Thanks