DP-700 - Ingest and Transform Data - Section 2.2
Prepare data for loading into a dimensional model, including slowly changing dimensions and surrogate keys.
Design star schema fact and dimension tables within the medallion architecture (bronze, silver, gold), generating surrogate keys to decouple from business keys. Choose between slowly changing dimension Type 1 overwrite and Type 2 history-preserving row versioning to meet retention requirements.
star schema fact and dimension tablesslowly changing dimensions (Type 1 and Type 2)surrogate keys and business keysthe medallion architecture (bronze, silver, gold)conformed dimensions
More in this domain
Back to all Ingest and Transform Data objectives, or the DP-700 cert hub.
Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.