colin.sql

Techniques for maintaining referential integrity in dimension tables.

Using dimension tables for drill-down analysis.

Implementing slowly changing dimensions in Snowflake schema.

Techniques for tracking changes in dimension tables over time.

Guidelines for managing surrogate keys in dimension tables.

 previous next 