DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
which is not a data warehouse operation?
|
|
slice
|
|
|
pivot
|
|
|
dice
|
|
|
drill right
|
Explanation:
Detailed explanation-1: -Answer-D) Volatile is not a property of the data warehouse.
Detailed explanation-2: -Drill down is a capability that takes the user from a more general view of the data to a more specific one at the click of a mouse. For example, a drill down report that shows sales revenue by state can allow the user to select a state, click on it and see sales revenue by county or city within that state.
Detailed explanation-3: -There are primary five types of analytical OLAP operations in data warehouse: 1) Roll-up 2) Drill-down 3) Slice 4) Dice and 5) Pivot.
Detailed explanation-4: -The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.
There is 1 question to complete.