Multiple independent flows in one parallel job

schp9 · Post by **schp9** » 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!

Thomas.B · Post by **Thomas.B** » 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.

FranklinE · Post by **FranklinE** » 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.