Page 1 of 1
Target Load Order
Posted: Wed Sep 18, 2013 10:04 am
by Roopanwita
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,
Posted: Wed Sep 18, 2013 11:17 am
by chulett
That topic is specifically about multiple "pipelines" - jobs within a job. Is that what you have? Or do you have a single (quote normal unquote ) job that writes to multiple target tables with FK dependencies between them?
Posted: Thu Sep 19, 2013 2:37 pm
by eph
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
Posted: Fri Sep 20, 2013 8:08 am
by asorrell
By "upper right" he really meant "upper left"...
Posted: Fri Sep 20, 2013 9:05 am
by chulett
And we still need a clarification from Roopanwita as to what exactly it is they are needing help with.
Posted: Thu Sep 26, 2013 1:01 pm
by Roopanwita
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:
Code: Select all
Source --> Copy -->Target1
--> Target2
--> Target3
Thanks,
Roopanwita