Is the load process incremental or do you reload all of the data every day?
If the tables are getting bigger, it is normal that the load time increases a bit.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP