PHQ, a graphics firm, decides to filter its employees according to their dates of joining. Which of the following steps in the extract-transform-load (ETL) process should be taken by the firm to accomplish the task?
a. Extract
b. Autorun
c. Load
d. Transform
a. Extract
The extract step in an extract-transform-load (ETL) process is designed to access the various sources of data and pull from each source the data desired to update a data warehouse. For example, the extract process may be designed to pull only a certain subset of orders from the Orders database—such as only those orders shipped after a certain date.
You might also like to view...
Discuss how disaster response is primarily supported.
What will be an ideal response?
For the following Web page, list all of the objects and actions
Discuss the impact (and draw an example) of using a sentinel node or dummy node at the head of a list.
What will be an ideal response?
For what purpose was C originally designed?
A. As a foundation for Windows. B. To write programs. C. To beat out Linux. D. As a basis for UNIX.