Santanu Patra

• Jun 29th, 2005

 

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.

Sathish

• Jul 4th, 2005

 

When a value for the column in the target table is looked up from another table apart from the source tables, that table is called the lookup table.

shivi

• Aug 26th, 2005

 

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

Muhammed Kamal

• Aug 30th, 2005

 

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.

PK

• Sep 26th, 2005

 

Based on responsibility how to protect/secure/hide even lookup values such as meaning?

senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

 

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.

can u explain in detail

Ramesh T.R

• Dec 15th, 2005

 

reference table can be otherwise called as lookuptable

yugandhar.bo

 Profile Answers by yugandhar.bo 

• May 13th, 2006

 

In DW Terminology the Dimension table is also called as Look up Table(Specific ib Business Objects)

since the index_key in the fact table is from(referencing) the particualr Dimension table so its also called as look up table.

ANIL

• Jun 28th, 2006

 

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.

mamatha

• Sep 1st, 2006

 

hi  

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

 mamatha

mrsnmd

 Profile Answers by mrsnmd 

• Aug 16th, 2008

 

When you design a DB you always use identification numbers to define objects instead of the actual name or description and store the description in a lookup table.
that makes any later update or insertion of any  name or description done only in one place. (Design issue)
the table containning the ID and description matche is called the lookup table. 

Johnson Weltch

• Dec 16th, 2016

 

This was great to know more about lookup table in database. You may also go through this informative article on look up table to get brief knowledge about Lookup table in database:
Lookup table in SQL Server at sqlmvp org

TimeBeing

• Jan 25th, 2017

 

Lookup for some related data in Database or Flatfiles or Database View based on key column