-
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.