Hi, I have a Datawarehouse SQL job with 8 steps. Basically the job will populate our Datawarehouse overnight. It will truncate all data in the datawarehouse overnight and reload
the data from the Transactional database.
each step in the job will load each dimention and fact table. Now the problem is its taking around 1 hour to run and I am looking into improve the speed.
I have started looking at the SQL queries in each SSIS package which is used to bring the data from the transacitonal Database. Can ony one please let me know if I need to
check any other areas which might be impacting that sql job in sql server 2008r2?