Hello,
The load plan Lp1 runs at 14:30 and takes around 140 mins to complete and Load plan Lp2 which runs at 15:00 takes 30 mins to complete are used to load the dimension tables. Sometimes the time varies and hence it is not fixed.
Another load plan Lp3 is used to load the Fact table. The fact table is daily refreshed using the dimension tables updated in the Lp 1 and Lp2.
I have a situation where I would like to add a step that checks if both the Load plans have completed and then trigger Lp3.
Kindly please suggest! How will dependency be created to first check if Lp1 and Lp 2 is completed and then trigger Lp3.