Successful Run of sppUpdateDW But No New Data on Tables

If running the nightly job for sppUpdateDW is successful but no new data is being added to the tables, you can clear the tables and reset this process.

sppUpdateDW keeps track of the last DEX_ROW_ID entered so that it doesn't grab data twice. To do a full reset, run a delete on every DW table and re-run the proc:

Delete all the data from these tables: dwConfig

dwCustomer_dim dwDatabaseVersion dwDate_dim dwInvoiceLine_fact dwItem_dim dwSalesDocLine_dim

Then re-run the sppUpdateDW. This will recreate all the data in the tables.