If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

What is bridge and lookup tables?

Started by anjani, 09 Jul 2008 10:26:42 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

anjani

09 Jul 2008 10:26:42 AM
What is bridge and lookup tables?




Thanks in advance

blom0344

#1
09 Jul 2008 01:17:19 PM
A bridge table is used for solving many to many relationships.
(Classis example is the one of students following classes; 1 student may attend more than 1 class and each class is attended by 1 or more students)
A lookup table is used for - example - looking up a description for a code.
The tables are often reused again and again in a model in different contexts (and aliased in the physical model to enable valid SQL)
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite