List of PostgreSQL scripts to generate data used for commonly needed dimension tables.
| Dim Table | Script | Overview |
|---|---|---|
| Date | create_dim_date.sql | Provides a comprehensive set of structured date attributes (e.g., year, quarter, month, week, day) that ensure consistency and reduced redundancy across different reports and analyses. |
| Person | create_dim_person.sql | Includes common attributes for persons. |