For constructing Data warehouse from operational databases, which of the following operations are necessary ?
MH SET - 2018, SET Exam - 2018,
Answer: A
The necessary operations are Extract and Load.
A data warehouse is built from operational databases by the ETL process: data is extracted from the source systems, cleaned and transformed into a consistent form, and loaded into the warehouse, usually in periodic batches.
Create and Edit and Query and Update are operations on operational (OLTP) data, not steps in building a warehouse. Slice and dice are OLAP operations used to analyse the warehouse once it exists.
Please log in or register to report this question.