Sorry if this questions seems to be simple. How to schedule using DAC. In the sense like if any data been added in one of my source table(OLTP) means then how it will reflect the new data back to my (OLAP) tables.
Any docs, describing about these steps.
Thanks in advance.
Seems you are looking for nearly real time refresh data.
Although it is possible but you have to think deeply before to do this. The cost of near real time refresh is extremely large than nightly refresh.
Following links might help. Re: Real Time Refresh Data in Dashboards
Please mark if help.