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. |