KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


What is a lookup table? 

Posted in Data WareHousing Interview Questions

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.

Post Your Answer!
Send This to a Friend

← Why should you put your data warehouse on a different system than your OLTP system?
What is ODS? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • Declarative Exception Handling  22.12.08

    If you have developed web applications long enough, you will realize a recurring pattern emerges: when the backend (e.g. the EJB tier) throws you an exception,...

  • Define XLAT instruction used in 8086.  14.11.08

    It translates a byte in AL using a table in memory. The offset address is calculated by adding the 8 bit contents of the AL register and the contents of BX reg...

  • What is a lookup table ?  23.09.08

    A lookup table is nothing but a 'lookup' it give values to referenced table (it is a reference), it is used at the run time, it saves joins and space in terms o...

  • What is the difference between unix and windows?  20.08.08

    Unix and Windows use completely different paradigms for run-time loading of code. Before you try to build a module that can be dynamically loaded, be aware of h...

  • What are the types of tables?  14.04.07

    1) Transparent table 2) Pool table 3) Cluster table are data dictionary table objects 4) Sorted table 5) Indexed table 6) Hash table 7) Internal tables....

  • Explain the methods, rebind() and lookup() in Naming class?  06.02.07

    rebind() of the Naming class(found in java. rmi) is used to update the RMI registry on the server machine. Naming. rebind(”AddSever”, AddServerImpl); lookup...

  • What is the Translation Lookaside Buffer (TLB)?  30.06.06

    In a cached system, the base addresses of the last few referenced pages is maintained in registers called the TLB that aids in faster lookup. TLB contains those...

  • Do you know what a local lookup is?  17.03.06

    This function is similar to a mlookup...the difference being that this funtion returns NULL when there is no record having the value that has been mentioned in...

  • What is LookUp table ?  16.03.06

    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...

  • What is the Translation Lookaside Buffer (TLB)?  08.03.06

    In a cached system, the base addresses of the last few referenced pages is maintained in registers called the TLB that aids in faster lookup. TLB contains those...