| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: Bridge Table
Answer: What is the use of bridge table. Can give a simple example? |
| October 10, 2009 07:25:06 |
#4 |
| vijsarav11 |
Member Since: October 2009 Total Comments: 1 |
RE: Bridge Table
|
Hi all... This is my view on bridge tables:
Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id.
It can be explained in detailed with the below example.
Say, 2 customer have taken two mortgage loans in a bank in such a way that in one loan with 2 borrowers and another with only one.
In order to link Customers with the Account, the table structure can be designed as:
Accounts - Table:
----------------------
AccountId Account_Open_Date
10123 05-02-1975
14535 06-08-2000
Customer - Table:
-----------------------
CustomerId Customer_Name Customer_Status
25366 Jon Burvill Primary
25367 Mariola Secondary
Customer Bridge Table:
------------------------------
Customer_Bridge_Id Account_Id Customer_Id
7894654 10123 25366
7894655 10123 25367
9656456 14535 25366
When Customer & Customer Bridge Id are called, then the data with account details will be retreived.
Regards
Viji
|
| |
Back To Question | |
