RA and BI tips:

Compression table use FROM_DT_WID and TO_DT_WID columns to indicate the time range in which records are valid.

Current Table stores latest positional fact data at the base level. Defined in day dimension levels

Flow:

Taken to the staging table or fact table first.

Temp table from facts table with surrogate keys for ease of processing

If data in temp table is new, inserted into the target table as well. If it’s changed data in temp table, existing record changed date and new record added.

current table loaded with latest facts.

As was and as is aggregates are made. If hierarchy changes, the tables need to be regenerated.

Positional facts aggregation, seasonal facts aggregation , and numerical facts aggregation are basically the types of aggregation available.

RFMP table for customer contains recency score, monetary score, profitability scores and so on.