A Data warehouse Basics Topics
1 DATA WAREHOUSE
1.1 What is Data Warehouse DAY 1
1.2 Why Data Warehouse
1.3 OLTP Online Transaction Processing
1.4 OLTP VS Data Warehouse ( OLAP)
1.5 Criteria for Selecting a Warehouse
2 DATA WAREHOUSE ARCHITECTURE
2.1 Process View DAY 2
2.2 Data Warehouse Structure
2.3 Schema Design
2.3.1 Dimensions And Facts
2.3.2 Star Schema
2.3.3 Fact Contellation Schema
2.3.4 Snow Flake Schema
3 Data Storage in Data Warehouse
3.1 Data Granularity in Warehouse DAY 3
3.2 Estimate of Data Volume
3.3 Dual Level of Granularity
3.4 What must be the Granularity Level
3.5 How to Control Granularity
3.6 Levels of Granularity
3.7 Partitioning
3.7.1 Why Partitioning
3.7.2 Criterion for Partitioning
3.7.3 Partitioning Examples
3.9 Denormalization
3.9.1 Create Arrays
3.9.2 Selective......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 1479
Approximate Pages: 6 (260 words per double-spaced page) |