Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have an app that is pulling data from a regular SQL database. The DB is structured in such a way that it creates fact tables for every month of the year:
Order_2015_Jan
Order_2015_Feb
Order_2015_Mar
Order_2015_May
Sometimes they do not always run sequential and miss a month. I need to load each of these tables once they are created so the app can report on those months. I can obviously open the app each month and create a LK_Key and load the new table but I need to automate this process. Any idea's?
Many Thanks
Nick
You can query the available tables using
This should allow you to create a FOR EACH ... NEXT loop in your script to iterate over the order tables available.
You can schedule a periodic reload task for this script or (if your have some kind of external trigger that may inform you about a new table has been created, you can use an EDX trigger approach to reload your script: