Hi,
I have to design a job for the following problem.
There are two table say table1 and table2. Table1 refrences table2 by Foreign key relationship.
Is there any possible way to load these two table simultaneously in one job?
Please suggest me any alternative.
Thanks in advance.
Birendra
Suggest the job design
Moderators: chulett, rschirm, roy
Suggest the job design
Birendra
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not really. You have to ensure that the parent record (in the referenced table) is in place before writing any child record (in the referencing table).
The only exception is when you use the Slowly Changing Dimension stage (version 8.0 and later), which manages this for you.
The only exception is when you use the Slowly Changing Dimension stage (version 8.0 and later), which manages this for you.
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.