DSXchange

There is two different flow in a single job.
One flow is populating to the parent table.
Second flow is populating to the child table.

I want to execute the parent flow first and then the child flow.

src->tfm->parent table
scr->tfm->child table

Please suggest.

If they are independant in the job then you cannot control the execution order. If you need to do so, split the logic into 2 jobs and call them from a job sequence.

shaonli wrote:There is two different flow in a single job.
One flow is populating to the parent table.
Second flow is populating to the child table.

I want to execute the parent flow first and then the child flow.

src->tfm->parent table
scr->tfm->child table

Please suggest.

If you can change the job, then do this way.

src->tfm->parent table-->tfm-->scr->tfm->child table

Just do not pass anything in the transformer marked in red.
But this is not a good way of coding.

Then don't suggest it.

Two jobs, run in the proper RI order by a Sequence job or using whatever you've got for job control there.

I would not try anything funky, but just go with 2 jobs, as Arnd suggested.

I agree that its not a good way.

But the requirement he specified is that he needs to do that in a single job.

If sequencer is to be used then the job should be split into two.

So I could'nt get any other solution other than trying this one. If what I have mentioned is a very bad suggetion, then please excuse me.

Always push back on illogical requirements.