Bridge table in data warehouse

[888aaa]

Hi Every one,

I am new to this forum, i was assigned to design a data mart for marketing. we have customer dimension and fact table. Our business is loan mortgage. For each loan there are many customers. It will be many to many relation ship between fact table and customer dimension. Does anybody tell me how to go about that.

Any help is really appreciated,

Thanks
Ram

 

[avjoshi]

You answered it yourself. You'll need a bridge table.

Anand

 

[johnherman]

In the trade pubs and documentation, you may also find bridge tables referred to as associative or relation tables. These tables typically consist of mostly key fields, the primary keys of the two tables needing the many to many relationship. Sometimes there are more data elements, but often there are only two columns, both foreign keys.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright