Data Modeling – Dimension Table Effective Practices

Database Table I've had these notes laying around for a while, so, I thought I consolidate them here.   So, here are few guidelines to ensure the quality of your dimension table structures. Dimension Table Effective Practices The table naming convention should identify it as a dimension table. For example: Suffix Pattern: <<TableName>>_Dim <<TableName>>_D Prefix … Continue reading Data Modeling – Dimension Table Effective Practices

Data Modeling – Database Table Field Ordering Effective Practices

Database Table Field ordering can help the performance on inserts and updates and, also, keeps developer and users from having to search entire table structure to be sure they have all the keys, etc. Table Field Ordering Distribution Field Or Fields, if no distribution field is set the first field will be used by default.Primary … Continue reading Data Modeling – Database Table Field Ordering Effective Practices