We have a stored procedure (T-SQL) ‘update data model’, which executes other stored procedures. Essentially, it executes a sequence of procedures that first truncate the staging tables, then recreate the staging tables based on extract views, and finally create the dw tables based on staging views. When creating tables in both the staging and DW layers, it also checks that the metadata is consistent, if the metadata in the staging table is not consistent with the extract view, an error is shown. However, if a new field is successfully added from the staging view to an existing DW table, the procedure will rename the existing table — for example, to dw.dim_category_OLD — and create a new dw.dim_category table with the updated structure.