What is a lookup table?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a lookup table?

A lookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition.

(Continued on next question...)

Other Job Interview Questions

• What are the vaious ETL tools in the Market?
• Which columns go to the fact table and which columns go the dimension table?
• What does level of Granularity of a fact table signify?
• What are modeling tools available in the Market?
• What are the different architecture of datawarehouse?
• What are the methodologies of Data Warehousing.?
• What is VLDB?
• What is the difference between view and materialized view?
• What is fact less fact table? where you have used it in your project?
• What is ODS?
• More...