Data in Organizations with BI Solutions
Redundant Data
As data gets collected in the source systems, accumulated in transactional databases, and stored
for analysis in the data warehouses, companies will end up with multiple copies of the same data in all of these systems. However, the data is not going to be identical; it will be different in scope and volume. Typically, source systems retain data only for a limited time, and the data in these systems is present in its raw format.