Hi,
I am trying to load multiple target table , and I have Foreign Key defined in few tables.
Is there a way I can define load order (Load all the tables in same job).
I tried to search for post on same topic and found below , it says it can't be done:
viewtopic.php?t=135513&highlight=load+order
Is there any workaround.
Thanks,
Target Load Order
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Hi,
When you open the db2/oracle connector, click on the DB picture on the right upper corner (not on the links), then you should see an option Record Ordering (All records by default), where you can modify the order of load (link by link or row by row in for each link). Of course you have to check the link ordering in the corresponding tab.
Eric
When you open the db2/oracle connector, click on the DB picture on the right upper corner (not on the links), then you should see an option Record Ordering (All records by default), where you can modify the order of load (link by link or row by row in for each link). Of course you have to check the link ordering in the corresponding tab.
Eric
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Hi,
Thank you for response and sorry for delay in my reply.
I am trying to load multiple tables(Target) in same job (few tables has FK define)
I tried the find option Record Ordering, but I couldn't find that option(in Target Oracle Connector Stage) , can you please or link ordering in (copy stage).
My job design is as below:
Thanks,
Roopanwita
Thank you for response and sorry for delay in my reply.
I am trying to load multiple tables(Target) in same job (few tables has FK define)
I tried the find option Record Ordering, but I couldn't find that option(in Target Oracle Connector Stage) , can you please or link ordering in (copy stage).
My job design is as below:
Code: Select all
Source --> Copy -->Target1
--> Target2
--> Target3
Thanks,
Roopanwita