Hi,
I have a requirement to load three target tables which have parent and child relationship. I tried loading these three tables in a single job. The parent table got loaded and job got aborted due to referential integertity constraint in child tables.
Though i have ordered the output link using "Link Ordering" i am getting this error. We shall very well do the parent load in first job and child table load in second job.
But, can anyone please suggest how to perform this in a single job.
Thanks,
Raja
Load Parent and child table in a single job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Jan 08, 2008 7:21 am
- Location: Chennai