Early-arriving fact

Early-arriving fact

In the Data Warehouse practice of ETL, an early fact or early-arriving fact [ [http://www.rkimball.com/html/designtipsPDF/KimballDT57EarlyArriving.pdf Kimball, Ralph. Design Tip #57: Early Arriving Facts. August, 2004.] ] denotes the detection of a dimensional natural key during fact table source loading, prior to the assignment of a corresponding primary key or surrogate key in the dimension table. Hence, the fact which cites the dimension arrives early, relative to the definition of the dimension value.

Procedurally, an early fact can be treated as:
* an error, on the presumption that the dimensional attribute values should have been collected before fact source loading.
* a valid fact, whose collection pauses whilst the missing dimensional attribute value itself is collected.

References


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • Early life of Pope Benedict XVI — The early life of Pope Benedict XVI concerns the period from his birth in 1927 through the completion of his education and ordination in 1951. TOC Background and childhood (1927–1943) Joseph Alois Ratzinger was born on 16 April, Holy Saturday,… …   Wikipedia

  • Early B — Infobox musical artist Name = Early B Img capt = Img size = Landscape = Background = solo singer Birth name = Earlando Arrington Neil Alias = The Doctor Born = 1956 Died = November 9, 1994 Origin = flagicon|Jamaica Kingston, Jamaica Instrument =… …   Wikipedia

  • Early life and military career of John McCain — The early life and military career of John Sidney McCain III spans forty five years (1936 ndash;1981). McCain s father and grandfather were admirals in the United States Navy. McCain was born in the Panama Canal Zone, and attended many schools… …   Wikipedia

  • Witch trials in the Early Modern period — Punishments for witchcraft in 16th century Germany. Woodcut from Tengler s Laienspiegel, Mainz, 1508. The Witch trials in the Early Modern period were a period of witch hunts between the fifteenth and eighteenth centuries,[1] when across Early… …   Wikipedia

  • Poirot's Early Cases — Infobox Book name = Poirot s Early Cases title orig = translator = image caption = Dust jacket illustration of the first UK edition author = Agatha Christie cover artist = Margaret Murray country = United Kingdom language = English series = genre …   Wikipedia

  • Poland in the Early Middle Ages — According to the currently predominant opinion, the Slavic tribes were not indigenous to the lands that were to become Poland [This is the so called allochthonic theory; according to the autochthonic theory the opposite is true] , but their first …   Wikipedia

  • Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… …   Wikipedia

  • Data mining — Not to be confused with analytics, information extraction, or data analysis. Data mining (the analysis step of the knowledge discovery in databases process,[1] or KDD), a relatively young and interdisciplinary field of computer science[2][3] is… …   Wikipedia

  • Data warehouse appliance — In computing, a data warehouse appliance consists of an integrated set of servers, storage, operating system(s), DBMS and software specifically pre installed and pre optimized for data warehousing (DW). Alternatively, the term can also apply to… …   Wikipedia

  • Extract, transform, load — Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”