Data Warehouse Workshop
This is the mind map about the data warehouse workshop.
Tags:
Similar Mind Maps
Outline


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

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

Subject-oriented
Integrated
Time-variant
Nonvolatile

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

A central data repository where data from operational databases and other sources are integrated, cleaned and standardized to support decision making.