Author Question: Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip ... (Read 223 times)

joe · **on:** Jul 7, 2018

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards.

The zip codes that aren't in the standard format are reformatted. This process is called ________.A) extraction
B) transformation
C) loading
D) normalization

Question 2

A database record is a grouping of characters into a word, a group of words, or a complete number.

Indicate whether the statement is true or false