Home / Early arriving fact. / ODI / Early Arriving Facts or Late Arriving Dimensions

Early Arriving Facts or Late Arriving Dimensions

Add Comment Early arriving fact. , ODI Edit

Early Arriving Fact Also known as Late Arriving Dimensions.

An early arriving fact takes place when the activity measurement arrives at the data warehouse without its full context. In other words, the statuses of the dimensions attached to the activity measurement are ambiguous or unknown for some period of time.

An early arriving fact is also known as a late arriving dimension because the dimensional member will arrive after the activity measurement

In Extract-Transform-Load (ETL) terminology, an early arriving fact is when the ETL process performs a look up of a surrogate key in a dimension table using the natural key of a fact table, and no value is returned because the dimension record doesn’t exist yet.

Steps to Implement Early Arriving Fact in ODI

About test

0 comments:

Subscribe to: Post Comments ( Atom )