DSXchange

Posted: **Thu Mar 03, 2016 11:34 am**

I want to have 3 flows in by job like below

 
Source 1 -> Transformation -> Target1

Source 2 -> Transformation -> Target2

Source 3 -> Trasformation  -> Target3

How can I control these flows as below scenario?

All can be triggered together or each can triggered manually?

I am considering using parameters, but not getting clarity on how to control the flow.

Please help!

Posted: **Thu Mar 03, 2016 11:46 am**

According to my knowledge, you can't control 3 independent data flows in a single parallel job.
The only way is to split your job in 3 sub-Jobs and call them with a Sequence Job.

That's a lot of jobs.

Posted: **Thu Mar 03, 2016 12:01 pm**

I have a standard PX second job-flow in many jobs. It creates a stand-by dummy file if there is no data in the current day's input. It always runs.

As for control, Thomas is correct: that is what job sequences are for. Create one job for each flow (three in your sample) and create a job sequence for each scenario. Research the sequence stage palate for branching and logical controls. They are there. Job sequences are as parameterized as you want them to be.

DSXchange

Multiple independent flows in one parallel job

Multiple independent flows in one parallel job