| |
GeekInterview.com > Tech FAQs > Data Warehousing
| Print | |
Question: Look Up Tables
Answer: What are lookup tables? Why they are used? Where they are used? |
| July 07, 2008 05:10:15 |
#1 |
| ponnarasuk |
Member Since: May 2006 Total Comments: 1 |
RE: Look Up Tables
|
| When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table |
| |
Back To Question | |
