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
Multiple Flat Files as Input
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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