Ok, we are getting somewhere now. You have a data warehouse and it is running on data extracted from an OLTP database presumably.

Is your ETL process (extract,transform, load) process breaking because of schema changes in the OLTP database? Have you talked to the developers to make them aware that you need to know about schema changes? That's the easiest way to find out.

Do you have this on a development setup? Are the script changes stored in source control before being rolled out? What tools are you using? What's your development process?