Load Parent and child table in a single job

[ganesh.soundar]

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

[chulett]

What database? What stage? Try with an Array Size of 1 and see if that works in your design.