Sunday, 21 October 2012

Bridge Table in Datawarehouse

What is a Bridge Table??


A bridge table sits between a fact table and a dimension table and is used to resolve many-to-many relationships between a fact and a dimension. Bridge table will contain only two dimension column ,key columns in both dimension .

Suppose there are two dimensions Customer and Region,
create table Customer(Customer_id int, Name varchar(110));
create table Region(Country_id int, Desc varchar(50));

Bridge table is created by joining the two tables Customer and Region using dimension keys
create table Brige_table_Custregion (Customer_id int, Country_id int)

Note: Also Bridge table is fact less with no measures.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis