Data Warehouse Concepts,types of incrementals,types of facts and dimensions

Опубликовано: 27 Октябрь 2024
на канале: @SKRT_t

data warehouse
ETL
TYPES OF INCREMENTAL
fact
Transactional Facts: Capture detailed individual transactions.
Periodic Snapshot Facts: Capture data at regular intervals.
Accumulating Snapshot Facts: Track processes through their lifecycle stages.
Factless Facts: Capture events or relationships without quantitative measures.
Derived Facts: Computed from existing data.
Cumulative Facts: Represent data that accumulates over time.
dim
Conformed Dimensions: Consistent across multiple fact tables.
Slowly Changing Dimensions (SCD): Track changes over time.
Role-Playing Dimensions: Same dimension used in different contexts.
Junk Dimensions: Combine low-cardinality attributes.
Degenerate Dimensions: Keys in fact tables without dimension tables.
Shrink-Wrapped Dimensions: Mini-dimensions for performance.
Inferred Dimensions: Temporary records for unavailable data.
Static Dimensions: Unchanging data.
Rapidly Changing Dimensions (RCD): Frequently changing attributes.