Automating the administrative tasks

The solution you built through the chapter loads both dimensions and the fact in a star model for a given range of dates. Now suppose that you want to keep your datamart always updated. Would you sit every day in front of your computer, and run the same job over and over again? You probably would, but you know that it would not be a good idea. There are better ways to do this. Let's see how you can get rid of that task.