In an extract-transform-load (ETL) process, the mined data used to update a data warehouse is converted to a different format in the _____ step.
a. extract
b. autorun
c. load
d. transform
d. transform
In the transform step in an extract-transform-load (ETL) process, the data that will be used to update a data warehouse is edited and, if necessary, converted to a different format. For example, a store identifier present in a detailed transaction record may be converted to a less specific identifier that enables a useful aggregation of the data.
You might also like to view...
Which type of report prints a line for all records that match a set of conditions?
A) detailed B) exception C) summary D) selected item
Which one of the following actions is not required under the EU General Data Protection Regulation?
A. Organizations must allow individuals to opt out of information sharing. B. Organizations must provide individuals with lists of employees with access to information. C. Organizations must use proper mechanisms to protect data against unauthorized disclosure. D. Organizations must have a dispute resolution process for privacy issues.
List and explain the six basic files in the general ledger database.
What will be an ideal response?
What is the output of the following C++ code? int list[5] = {0, 5, 10, 15, 20};int j;for (j = 1; j
A. 0 5 10 15 20 B. 5 10 15 20 0 C. 5 10 15 20 20 D. Code results in index out-of-bounds