Dwdm 1exp 3,4 bits

 Exp 2:

3). Write ETL scripts and implement using data warehouse tools

ETL is the most important process in SSIS tool. ETL is used to Extract, Transform, and Load the data into a data warehouse.

ETL is a process responsible for pulling out the data multiple data sources, transforming the data into useful data, and then storing the data into a data warehouse. The data can be in any format xml file, flat file, or any database file.

It also ensures that the data stored in the data warehouse is relevant, accurate, high quality, and useful to the business users.

It can be easily accessed so that the data warehouse can be used effectively and efficiently.

It also helps the organization to make data-driven decisions by retrieving the structured and unstructured data from multiple data sources.

ETL diagram //Click on the link and draw the diagram from the link//

4. Perform Various OLAP operations such as slice,dice, roll up, drill up and pivot OLAP OPERATIONS: 

OLAP having 5 different operations 

(i) Roll-up 

(ii) Drill-down 

(iii) Slice 

(iv) Dice 

(v) Pivot 

Roll-up: 

The roll-up operation performs aggregation on a data cube, by climbing down concept hierarchies, i.e., dimension reduction. Roll-up is like zooming-out on the data cubes. 

It is also known as drill-up or aggregation operation 

//Roll-up diagram Note down from your class notes//

Drill-Down 

The drill-down operation is the reverse operation of roll-up. 

It is also called roll-down operation.

Drill-down is like zooming-in on the data cube. 

It navigates from less detailed record to more detailed data.

/////Draw the drill down diagram from your notes/////

Slice: 

A slice is a subset of the cubes corresponding to a single value for one or more members of the dimension.

The slice operation provides a new sub cube from one particular dimension in a given cube. 

////Draw the slice diagram from your notes////

Dice: 

 The dice operation describes a sub cube by operating a selection on two or more dimension. 

////Draw the dice diagram from ur notes////

Pivot: 

The pivot operation is also called a rotation.

It may contain swapping the rows and columns or moving one of the row-dimensions into the column dimensions. 

/////Draw the pivot diagram from your notes////