Splitting a file based on data in a different file

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
GoinBuggy
Participant
Posts: 3
Joined: Fri Nov 03, 2006 9:15 am

Splitting a file based on data in a different file

Post by GoinBuggy »

WTx v8.1

I have a file I receive from an external source. I have to seperate the file into two files based on a code. The code is not in the file received it is in a seperate file. The two files are correlated by Customer ID.

How should I approach building the .mtt and the .mms?

Does this make sense?

Thanks for the help.
Top
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

If your files are in sorted order use searchup/searchdown its much faster.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage TX”