Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit-II (Principles of Dimensional Modeling (Dimensional Modeling (Updates…
Unit-II
Principles of Dimensional Modeling
From Requirement to Data Design
The STAR Schema
STAR Schema keys
Advantages of STAR Schema
Dimensional Modeling
Updates to the Dimensional Tables
Miscellaneous Dimensions
The Snowflake Schema
Aggregate Fact Tables
Families of STARS
Data Extraction
Data Transformation
Data Loading
Infrastructure as the Foundation for Data Warehousing
Infrastructure Support Architecture
Hardware Operational System
Database Software
Collection of Tools
The Architectural Component
Understanding Data Warehouse Architecture
Distinguishing Characteristics
Architectural framework
Technical Architecture
The Significant Role of Metadata
Why Metadata is Important
Business Metadata
Metadata Types by Functional Areas
How to Provide Metadata
OLAP in the Data Warehouse
Demand for Online Analytical Processing
Major Features and Functions
OLAP Models
OLAP Implementation Consideration