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 of transformations. Example, a lookup table called states, provide actual state name ('Texas') in place of TX to the output.
When a table is used to check for some data for its presence prior to loading of some other data or the same data to another table the table is called a LOOKUP Table.
when we want to get related value from some other table based on particular value... suppose in one table A we have two columns emp_id name and in other table B we have emp_id adress in target table we want to have emp_id name address we will take source as table A and look up table as B by matching EMp_id we will get the result as three columns...emp_id name address
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 of transformations. Example a lookup table called states provide actual state name ('Texas') in place of TX to the output.
Santanu Patra Wrote: When a table is used to check for some data for its presence prior to loading of some other data or the same data to another table the table is called a LOOKUP Table.
hi The Look Up table provides the detailed information about the attributes.For example the lookup table for the quarter attribute would include a list of all the quarters available in the data warehouse.i.e. first quarter of 2001 may be represented as Q1 2001 or 2001 Q1 .BYE.
if the data is not available in the source systems then we have to get the data by some reference tables which are present in the database.these tables are called lookuptables
for example while loading the data from oltp to olap we have only natural keys in oltp we don't have the respected wh keys so we take the targetdimension table as lookup if the two natural keys match then get the value of the wh key
1 
0