Anchoring script for student Orientation in university

1.List down Industry domains where Data warehousing technologies have been deployed?

2. List and define the OLAP operations.
3. What are the data integration challenges and how to cater them?

OLAP Operations
One of the most compelling front-end applications for OLAP is a PC spreadsheet program. Below is the list of some popular operations that are supported by the multidimensional spreadsheet applications.

Roll-up

Takes the current aggregation level of fact values and does a further aggregation on one or more of the dimensions. Equivalent to doing GROUP BY to this dimension by using attribute hierarchy. Decreases a number of dimensions – removes row headers.

SELECT [attribute list], SUM [attribute names]
FROM [table list]
WHERE [condition list]
GROUP BY [grouping list];
Drill-down
Opposite of roll-up.

Summarizes data at a lower level of a dimension hierarchy, thereby viewing data in a more specialized level within a dimension. Increases a number of dimensions – adds new headers

Slice
Performs a selection on one dimension of the given cube, resulting in a sub-cube.

We will write a custom essay sample on
Anchoring script for student Orientation in university
or any similar topic specifically for you
Do Not Waste
Your Time
HIRE WRITER

Only $13.90 / page

Reduces the dimensionality of the cubes. Sets one or more dimensions to specific values and keeps a subset of dimensions for selected values. Dice Define a sub-cube by performing a selection of one or more dimensions. Refers to range select condition on one dimension, or to select condition on more than one dimension. Reduces the number of member values of one or more dimensions.

Pivot (or rotate)
Rotates the data axis to view the data from different perspectives. Groups data with different dimensions.

Drill-across
Accesses more than one fact table that is linked by common dimensions. Combines 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. Cross-tab
Spreadsheet style row/column aggregates.

How to cite this essay

Choose cite format:
Anchoring script for student Orientation in university. (2016, Jun 12). Retrieved December 13, 2019, from https://newyorkessays.com/essay-anchoring-script-for-student-orientation-in-university/
A limited
time offer!
Get authentic custom
ESSAY SAMPLEwritten strictly according
to your requirements