im reviewer

valid time lag

 is the difference between the occurrence of an event in the real world (valid time) and the storage of the event in an operational database (transaction time).

load time lag

is the difference between transaction time and the storage of the event in a data warehouse (load time). For internal data sources, there may be some control over valid time lag.

cooperative change data

change data involves notification from the source system about changes. The notification typically occurs at transaction completion time using a trigger.

log change data

change data involves files that record changes or other user activity. 

snapshot change data

change data involves periodic dumps of source data.

Parsing

Locates and separates individual data elements in text

standardization

Applies conversion routines to transform data into preferred formats

Grain

Finest level of detail of the fact table

Sparsity

Space in rows are empty

True

true or false

true

true or false

true

true or false

false

true or false

false

true or false

true

true or false

customer relationship management

what does crm stands for?

true

true or false

true

true or false