Target Load Order

[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,

[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?

[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

[asorrell]

By "upper right" he really meant "upper left"...

[chulett]

And we still need a clarification from Roopanwita as to what exactly it is they are needing help with.

[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