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.

Computer Science & Information Technology

You might also like to view...

Discuss how disaster response is primarily supported.

What will be an ideal response?

Computer Science & Information Technology

For the following Web page, list all of the objects and actions

Computer Science & Information Technology

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?

Computer Science & Information Technology

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.

Computer Science & Information Technology