Data Warehousing Concepts and Data Warehouse Project Lifecycle

by BIDW Team on June 15, 2010

Data Warehousing Concepts

What is Data Warehouse
OLTP vs OLAP : Difference
What is dimensional modeling
What is star schema
What is snowflake schema
What is slowly changing dimension
SCD Type 1
SCD Type 2
SCD Type 3
What is surrogate key
What is Metadata
Whats is ODS
Data Warehouse Conceptual Data Model
Data Warehouse Conceptual Logical Model
Data Warehouse Conceptual Physical Model
Data Warehouse Conceptual Semantic Model

Data Warehouse Project Lifecycle

Data Warehouse Lifecycle
Problem Analysis and Design
Requirement Gathering and Analysis
Prototyping
Environment Setup
Design and Development
Testing
Deployment and Training
Enhancement and Helpdesk

Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!

Related posts:

  1. Data Warehouse Project Life Cycle
  2. Design and Development
  3. Conceptual Data Model

Leave a Comment

Previous post:

Next post: