Hi all,
I need to load around 20 tables , i have separate jobs for each one of them.
Daily some of the records are rejected in one or all jobs and i have an error file to capture them with different user defined error messages ( a single file for all jobs)
Each record will have an unique no.
Now my req is i need to capture the record which is rejected for very first time.
For example if a record is rejected in 3rd,13th and 20th jobs then my error file should contains the rejected record in 3rd job.
Thanks in advance
Capturing the non existing records
Moderators: chulett, rschirm, roy
I would probably initially capture them to separate reject / error files and then add a post-processing job that builds the combined / finalized file and enforces your 'only from the first job' rule. Of course you'd need some kind of intelligent naming convention so they sort properly in order to facilitate that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: