Page 1 of 1
Multiple Flat Files as Input
Posted: Tue Feb 04, 2003 8:14 am
by Gurudutt
I have a situation where I Have to use two flat files as input and the output is also a flat file. Please let me know how we can do this in datastage. This is concat of UNIX(Append). The source should not be disturbed.
GD
Posted: Tue Feb 04, 2003 5:02 pm
by ray.wurlod
Go to the job properties and select ExecSH as a before-job subroutine providing an appopriate command as the Input Value. For example:
cat file1 file2 > file3
Then have DataStage process file3.
There are other ways, but this is the fastest and most efficient.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518