Wondershare EdrawMind
EdrawMindData Warehouse Workshop
MindMap Gallery Data Warehouse Workshop
- 256
- 5
Data Warehouse Workshop
This is the mind map about the data warehouse workshop.
Edited at 2020-10-10 03:37:15- Mind Map Kingdom
Mind maps are a great resource to help you study. A mind map can take complex topics like plant kingdom and illustrate them into simple points, as shown above.
- Team Communication Strategies
Mind maps are useful in constructing strategies. They provide the flexibility of being creative, along with the structure of a plan.
- Types of Vitamins
Vitamins and minerals are essential elements of a well-balanced meal plan. They help in ensuring that the body is properly nourished. A mind map can be used to map out the different vitamins a person requires.
Data Warehouse Workshop
- Mind Map Kingdom
Mind maps are a great resource to help you study. A mind map can take complex topics like plant kingdom and illustrate them into simple points, as shown above.
- Team Communication Strategies
Mind maps are useful in constructing strategies. They provide the flexibility of being creative, along with the structure of a plan.
- Types of Vitamins
Vitamins and minerals are essential elements of a well-balanced meal plan. They help in ensuring that the body is properly nourished. A mind map can be used to map out the different vitamins a person requires.
- Recommended to you
- Outline
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.