Which term best describes the process of combining analytically useful data from multiple operational databases into a single data warehouse?

Which term best describes the process of combining analytically useful data from multiple operational databases into a single data warehouse?

• A. Time variant
• B. Integrated
• C. Structured repository
• D. Subject orientated

Answer: (B)

Data integration is the process of pulling data from multiple operational databases and bringing it into one unified data warehouse. The goal is to create a single, coherent view with consistent definitions, formats, and units so analysts can run cross-source analyses. In practice, this is often done with ETL (extract, transform, load) operations that extract from each source, transform the data to a common model, and load it into the warehouse. While the warehouse data is time-variant and organized around subjects, those describe properties of the warehouse itself rather than the merging step. So the term that best fits the act of combining data from multiple sources is integration, producing an integrated data view.

Data integration is the process of pulling data from multiple operational databases and bringing it into one unified data warehouse. The goal is to create a single, coherent view with consistent definitions, formats, and units so analysts can run cross-source analyses. In practice, this is often done with ETL (extract, transform, load) operations that extract from each source, transform the data to a common model, and load it into the warehouse. While the warehouse data is time-variant and organized around subjects, those describe properties of the warehouse itself rather than the merging step. So the term that best fits the act of combining data from multiple sources is integration, producing an integrated data view.