Clean vs. Dirty Data
Data in source systems and transactional databases is typically as is, as it most likely has not
undergone any review or scrubbing. Data in data warehouses is much cleaner. It has been analyzed for outliers, scrubbed, and erroneous data has been removed or corrected; thus it is more suitable for
conducting further analysis.