DSXchange

quote: Originally posted by ds_developer [br]Don't use the Merge stage - it is worthless in my opinion. The trick is 3 sequential stages in a row: the Input of the second stage is set to overwrite with the new file name, the Input of the 3rd stage is set to append with the new file name and the Outp...

quote: Originally posted by JDionne [br]quote: Originally posted by Ray.Wurlod [br]In UNIX it's cat, in Windows it's either type or copy. Before the job runs, execute this command (perhaps through a before-job subroutine invoking ExecDOS): type file1 file2 > file3 Then your job processes file3, whic...

quote: Originally posted by datastagedummy [br]The easiest way is just to merge the files using cat command in unix and feed it to your existing job :( im in a windows world. Is there a way to get datastage to do this for me? Im playing with two sequncial stages going into one bulk loader, but I am ...

I have two sequncial files that I need to load into a stage table. The files are both the same format, just two different subsets of data based on time. How do I load both files in one job?
Regards Jim