Where do the data input streams for data warehouses primarily come from?
Data warehouses are built by extracting, transforming, and loading data mainly from an organization's operational databases (transaction processing systems), which capture the day-to-day business activities. These operational systems serve as the principal source feeding the data warehouse, even though supplementary data may occasionally come from other sources such as third parties or external websites.
Community Discussion