What are the list of OLAP operations in data warehouse?
Auto Amazon Links: No products found.
There are 5 types of OLAP operations in data warehouse.
Below is the description of each operation:
Roll-up: Roll-up is also known as “consolidation” or “aggregation.” The Roll-up operation can be performed in 2 ways i.e. reducing dimensions and Climbing up concept hierarchy.
Drill-down: In drill-down data is fragmented into smaller parts. It is the opposite of the rollup process. It can be done via moving down the concept hierarchy and increasing a dimension.
Slice: In this operation, one dimension is selected, and a new sub-cube is created.
Dice: This operation is similar to a slice. The difference in dice is you select 2 or more dimensions that result in the creation of a sub-cube.
Pivot : In Pivot, you rotate the data axes to provide a substitute presentation of data.
Auto Amazon Links: No products found.