Data Flows - Chaining of Data Flows
We had a requirement to execute a data flow based on success or failure of another flow.
So, the first data flow will process a million records and will segment them. Upon completion of segmentation another data flow has to be triggered to route work to appropriate channel.
There are two data flows DATAFLOW1 and DATAFLOW2.
DATAFLOW2 must be triggered automatically after completion of DATAFLOW1. This sort of chaining can be extended i.e. DATFLOW3 might have to be triggered based on DATAFLOW2.
I have attached the solution we have implemented. Please let me know if there is any better approach.
We have also explored the option of using intermediate control tables, but we preferred this approach.