I have a scheduled execution package which takes data from ODX, transforms data in DSA database and loads final tables to MDW. This execution package basically runs a perspective containing this process.
I need to setup following logic:
- If data in any source table (ODX) of this execution package is empty (i.e. at least 1 empty table)
- Do not execute the package
- If data in all source tables (ODX) of this execution package contain any data (i.e. all tables non-empty)
- Execute the package
Is there any way how i can setup this? Maybe even create additional “control” execution package? The version of TX i am running is 184.108.40.206
Best answer by rogier.helmusView original