In a data warehouse environment, there’s often a separate database used by the ETL process that's typically called the staging database. The tables in this database might bear little to no resemblance to the tables in the final data warehouse; some are landing places for transactional and non-transactional datasources as they enter the data warehouse environment. Other tables are used as intermediate steps in the checking, scrubbing, separating, decoding, validating, and verifying portions...