You must collect and process these records by fixing the bad components of the fact table keys. This load exception processing is a separate application. Index the newly loaded records. Once all of the data is loaded, you must rebuild all of the affected indexes. You may need an application to keep track of the status of these indexes.
Quality assure the data load.
Remember that you have the same responsibilities as a traditional publisher. The publishing step is a manual or perhaps even an automated email message to all users, each morning, summarizing the status of the previous day's load. This is a very valuable step and is much appreciated by the users. It is part of your publishing responsibility. Stepping Out This list of steps varies from data warehouse to data warehouse, and may be arranged in a different order, but it is difficult to leave out any of these steps.