A database administrator adds demographic data from the U.S. Census Bureau to the company's customer records with zip codes before loading it into the data warehouse. This process is called the ________.
A) extraction process
B) transformation process
C) assimilation process
D) normalization process

Question

Quizplus · Accepted Answer

The process of adding demographic data from the US Census Bureau to the company's customer records with zip codes involves transforming the data by merging it with the customer records. This is known as the transformation process in ETL (Extract, Transform, Load) data integration. The extraction process involves gathering data from multiple sources, assimilation refers to integrating data into a single repository, and normalization is a data modeling technique to organize data in a structured way.

A Database Administrator Adds Demographic Data from the U