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.