Relational Data Modeling - (Xref|Cross-reference|Lookup) table

Data System Architecture

About

A lookup table is a table that is also known as:

  • XREF
  • or cross-reference table

A lookup is when a query joins the base table and the lookup table to obtain the values of the lookup table for each row in the base table.





Discover More
Data System Architecture
Collection - HashMap (Hash table)

A hash map is an implementation of a map that stores the data in buckets. The distribution of the data to a bucket is via the hash value of the key map entry (hence a HashMap). A hash map is used...
Data System Architecture
Data Warehouse

A data warehouse is a large central data repository of current, history and summarised data coming from operational and external sources used primarily for analysis. s is large historical databases for...
Obiee11g Lookup Table
OBIEE 11G - Lookup Function

A lookup in OBIEE is performed: in 10g with the help of a outer of inner join in 11G with the lookup function In 11g, the lookup function was introduced in a localization perspective. It permits...
Key Lookup Inputconnection
OWB - Key lookup operator

Use the Key Lookup operator to lookup (retrieve) data from a set of data (filter,table, view, cube, or dimension ...) For example, use the Key Lookup operator when you define a mapping that loads...



Share this page:
Follow us:
Task Runner