COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drill Down
|
|
|
Transform
|
|
|
Extract
|
|
|
Load
|
Detailed explanation-1: -The drill-down operation (also called roll-down) is the reverse operation of roll-up. Drill-down is like zooming-in on the data cube. It navigates from less detailed record to more detailed data. Drill-down can be performed by either stepping down a concept hierarchy for a dimension or adding additional dimensions.
Detailed explanation-2: -DRILL ACROSS: Accesses more than one fact table that is linked by common dimensions. COmbiens cubes that share one or more dimensions. DRILL THROUGH: Drill down to the bottom level of a data cube down to its back end relational tables.
Detailed explanation-3: -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.