Parent Child Load

[jerome_rajan]

We have a source file that contains hierarchical data. I'm using a DataStage jbo to separate the parent from the children and the grand children into 3 different links. The target is an Oracle table with the children going into nested tables within the parent table. What would be the best way to sequence this load?

Currently, I'm loading the children and the grandchildren into 2 datasets whilst loading the parent in the first job. And then in 2 subsequent load jobs, I'm loading the child records first and then the grandchild records.

Is there a better way to do this?

[ray.wurlod]

You might experiment with a Connector with multiple input links, which should give you you ability to create a transaction across all three tables where a particular key value is shared.

But what you are doing will work too.

[jerome_rajan]

Hi Ray,

I'm on DataStage 8.1 and I don't think the Oracle connector will accept multiple inputs.