Data Warehouse Workshop

Data Warehouse Workshop
Process flow
Design target object metadata
Tool
Design Center
Dimension Editor
Cube Editor
Extract source metadata
Tool
Design Center
Import Source Metadata
Profile data and Correct data
Tool
Design Center
Profile Editor
Profile
Correction
Map source to target with transformations
Tool
Design Center
Mapping Editor
Validate, generate and deploy the code
Tool
Design Center
Mapping Editor
Validate
Generate
Control Center Manager
Deploy
Extract, transform and load data
Tool
Design Center
Control Center Manager
Execute Mapping
Glossary
Configuration
Cube
Data Warehouse
Data Mart
Independent Data Mart
Dependent Data Mart
Dimension
Fact Table
ETL
Repository
Repository Owner
Repository User
Target User
Snowflake Schema
Staging area
Star Schema
Characteristics
Subject-oriented
Integrated
Time-variant
Nonvolatile
Comparison of Operational database (OpDB) and Data warehouse (DW)
Currency
Current (OpDB)
Historical (DW)
Detail level
Individual (OpDB)
Individual and summary (DW)
Orientation
Process orientation (OpDB)
Subject orientation (DW)
Number of records processed
Few (OpDB)
Thousands (DW)
Normalization level
Mostly Normalized (OpDB)
Mostly Denormalized (DW)
Update
Frequently (OpDB)
Rare (DW)
Data Model
Relational ERD (OpDB)
Relational Star Schema and Multidimension model (DW)
Relational Model
Star Schema
Snowflake Schema
Multidimensional Model
Definition
A central data repository where data from operational databases and other sources are integrated, cleaned and standardized to support decision making.
175 3