medium10 pts · first answer countsdata-pipelinesslowly-changing-dimensions
Daily snapshots versus SCD2 rows
A customer table has 2 million rows and about 1% of customers change each day. After 365 days, about how many rows does each approach store?
Discussion 0
Join free to post in the discussion.
Related questions
- ETL vs ELTData Engineer
- Idempotent pipelinesData Engineer
- Batch or streaming for a daily reportData Engineer
- Incremental logic for a tiny tableData Engineer
- What SCD Type 1 doesData Engineer
- Keeping the old customer segmentData Engineer
- Why a dimension has its own keyData Engineer
- The bronze layerData Engineer