How to control the load sequence of transformer outputs

[Amar_nath]

hi all,

In a job I am loading data from one ODBC.
I have a trnsformer with two output links connecting to ODBC stages OD1 and OD2.
I want to load the data in OD1 first and then in the OD2 (constraints are in transformer)
Is there any functionality for sequencing the loading of target stages ?


thanx in advance.

[loveojha2]

Yes, you can set the sequence of passing the data to the output links.
Open your transformer, and go to the properties, go to Link Ordering tab within the Stage tab. There you can specify the ordering.

[Amar_nath]

hey that just changes the sequence of links,
but the loading is done simultaneously but I want to change the order of loading the tables.

[loveojha2]

Let me understand your requirement,
do you want to load the data in OD2 after every thing is loaded into OD1?

[Amar_nath]

Yes, after loading of OD1 is completed then only OD2 's loading should be started .

[loveojha2]

Yes, after loading of OD1 is completed then only OD2 's loading should be started .

In that case you would need to split your job into two jobs called from within a sequence job,
first job would be for populating the OD1.
and on the sucessful completion of the first job, second job should populate the OD2.

[gateleys]

I am always in favor of having separate jobs to load two database stages. Becomes easier, for example if the second load fails for some reason, just rerun it. But, with your design... I dunno!!!

gateleys

[sb_akarmarkar]

We can do it in one job .... like

SourceODBC ----Input Data---> OD1--Dummy Input -->SourceODBC--Input Data-->OD2

Dummy Input = select 0 from OD1

But ......

My suggestion to go with two jobs

Thanks,
Anupam