Parent Child Load
Posted: Tue Sep 09, 2014 11:14 pm
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?
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?