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?
Parent Child Load
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Parent Child Load
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
But what you are doing will work too.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Hi Ray,
I'm on DataStage 8.1 and I don't think the Oracle connector will accept multiple inputs.
I'm on DataStage 8.1 and I don't think the Oracle connector will accept multiple inputs.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.