Hi, I want to start my tasks in the managment console as soon as the datawarehouse loadings are complete. Wheather loadings are done or not is found out with a simply select towards the DB. What would you say is the easiest way to solve this? Thanks in advance, br Paul
Our IT Operations department uses Control-M to trigger EDX tasks as tables in the data warehouse complete their nightly updates. This allows some QlikView apps to begin their data reloads even before the entire data warehouse is finished with its nightly processing.
Same for us. The Control-M schedule manages the end to end process across different technoligies and platforms. The database batch jobs for the warehouse are then followed immediately by the EDX triggered QlikView refresh tasks.