Answer Detail: RE: Bridge Table

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: Bridge Table

Answer: What is the use of bridge table. Can give a simple example?

February 02, 2009 19:36:20	#1
siva.3aug	Member Since: February 2009 Total Comments: 1
RE: Bridge Table
Bridge table is also known as helper table or reference table. If there is a many to many relationship between fact table and dimension table then we use bridge table to resolve this relationship (this bridge table is anology to associative entity between two entities having many to many relation ships). Bridge table is also used to flatten out the hierarchy in the dimension table. Thanks Siva