Joining Sequential Files
Moderators: chulett, rschirm, roy
Joining Sequential Files
I have 3 files with the same column definitions coming from 3 different jobs. I want to put all three files into one file in order to perform one lookup on a hashed file instead of three separate identical lookups.
Is there a way to put these files together?
Thanks,
Kevin
Is there a way to put these files together?
Thanks,
Kevin
i met save problem before. you can do as such
open job peoperty and click performence, then select inter process.donlank wrote:I tried the link collector already. It says, "Link Collector Stage does not support in-process active-to-active inputs or outputs"
So the only option to put three files into one in a Server Job is to write a Before Job Routine? There isnt a stage to accomplish this?
Thanks,
Kevin
anoter suggestion to your job is using multiple instanc, I believe that your job is a typical multi-instance job.
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
If you need just the hash file, and not the 3 individual sequential files, could you modify your 3 initial jobs to write to a hash file, rather than a sequential file ??
this way, all 3 jobs are writing to same hash file and when you are done with those, the next set of jobs can lookup on just this single hash file.
this way, all 3 jobs are writing to same hash file and when you are done with those, the next set of jobs can lookup on just this single hash file.
Hi jreddy
when doing that make sure that the first file writes to the hash will delete the content before writing the records. Otherwise you will have the old records stacked into it.
Thanks
when doing that make sure that the first file writes to the hash will delete the content before writing the records. Otherwise you will have the old records stacked into it.
Thanks
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar