Design Tip #142 Building Bridges

http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/

The dominant topologies of Data Warehouse modelling (Star, Snowflake) is designed with one-to-many relationships in mind. Query readability, performance, and structure degrades severely when faced with a many-to-many relationship in these mode Lling schemes.

??

1. Type2 Fact tables, how-to-let the BI-report tools like BO, micro-strategy support automatically extract correct date ra Nge data?

??

2.if one row in fact table have more than one row in the the dimension tables, what is should we do?

Normalize The fact table is a bad idea. It would cause your measures use more distinct for getting correct result.

Use a bridge table to join the fact table and dimension table.

??

3.add the bitmap index for the stage tables, if these tables we'll take a more batches. It'll be the more effective than B plus the tree index in this case.

http://docs.oracle.com/cd/E11882_01/server.112/e25554/indexes.htm#DWHSG8131

Design Tip #142 Building Bridges