I am going discusses two types of schema here, Start Schema and Snowflake Schema
Wednesday, December 26, 2012
Types Database Schemas
by Unknown | 
in DW
at 8:36 PM
Start Schema
A single Fact table surrendered by multiple
Dimension table is called Start Schema. It doesn’t capture hierarchy directly
Benefits of Start Schema
·
Performance (Integer relationships, natural
partitioning, Single joins benefit SQL optimizer)
·
Source system independence and multiple
integration
·
Supports Change management
·
Usability/Simplicity (easy to read, interpret,
join, calculate)
·
Presentation (Consistency, Taxonomy, Labeling)
·
Reuse (Conformed dimensions reduce redundancy,
Role-plays)
Snowflake Schema
It
represents the dimension hierarchy directly by normalizing tables
- What is ETL Mapping Document ?A Real Time Example
- Netezza Commands
- Datastage Error and reject record Handling simplified
- Data Generation Using DataStage
- Netezza Performance Check Querys
- Datastage Universe Quick Refrence
- Optimizing Business Objects Universe and Reports
- Use of Default or Dummy row in dimension table
- Conformed Dimensions with example
- DOS Batch Script to Export DataStage Jobs Automatically from a Project
0 comments: