The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a .....

DATA WAREHOUSING AND DATA MINING

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ____

A	Rollup
B	Drill down
C	Drill down
D	Pivoting

Explanation:

Detailed explanation-1: -The process of moving from finer granular data to coarser granular data is called as drill-down.

Detailed explanation-2: -The pivot operation is also known as rotation. It rotates the data axes in view in order to provide an alternative presentation of data. Consider the following diagram that shows the pivot operation.

Detailed explanation-3: -Pivoting: changing the dimensions used in a cross-tab is called. Slicing: creating a cross-tab for fixed values only. Sometimes called dicing, particularly when values for multiple dimensions are fixed.

Detailed explanation-4: -OLAP (online analytical processing) is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view.

Detailed explanation-5: -Answer. The generalization of cross-tab which is represented visually is two dimensional cube which is also called as data cube .

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING