Early-arriving fact (original) (raw)
In the Data Warehouse practice of ETL, an early fact or early-arriving fact 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:
| Property | Value |
|---|---|
| dbo:abstract | In the Data Warehouse practice of ETL, an early fact or early-arriving fact 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. * a valid fact, where a primary key value is generated on the dimension with no attributes (stub / dummy row), the fact completes processing, and the dimension attributes are populated (overwritten) later in the load processing on the new row. (en) |
| dbo:wikiPageID | 17116305 (xsd:integer) |
| dbo:wikiPageLength | 1494 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID | 1094042313 (xsd:integer) |
| dbo:wikiPageWikiLink | dbr:Primary_key dbr:Surrogate_key dbc:Data_warehousing dbr:Data_Warehouse dbc:Business_intelligence dbr:Dimension_table dbr:Extract,_transform,_load dbr:Fact_table dbr:Natural_key |
| dbp:wikiPageUsesTemplate | dbt:Reflist dbt:Short_description dbt:Data_warehouse |
| dcterms:subject | dbc:Data_warehousing dbc:Business_intelligence |
| rdfs:comment | In the Data Warehouse practice of ETL, an early fact or early-arriving fact 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: (en) |
| rdfs:label | Early-arriving fact (en) |
| owl:sameAs | freebase:Early-arriving fact wikidata:Early-arriving fact https://global.dbpedia.org/id/4ieBT |
| prov:wasDerivedFrom | wikipedia-en:Early-arriving_fact?oldid=1094042313&ns=0 |
| foaf:isPrimaryTopicOf | wikipedia-en:Early-arriving_fact |
| is dbo:wikiPageRedirects of | dbr:Early_arriving_fact |
| is dbo:wikiPageWikiLink of | dbr:Outline_of_databases dbr:Early_arriving_fact |
| is foaf:primaryTopic of | wikipedia-en:Early-arriving_fact |