Data Modeling – Fact Table Effective Practices

Database Table Here are a few guidelines for modeling and designing fact tables. Fact Table Effective Practices The table naming convention should identify it as a fact table. For example: Suffix Pattern: <<TableName>>_Fact <<TableName>>_F Prefix Pattern: FACT_<TableName>> F_<TableName>> Must contain a temporal dimension surrogate key (e.g. date dimension) Measures should be nullable – this has an … Continue reading Data Modeling – Fact Table Effective Practices

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

Software Development Life Cycle – What is RAD?

Acronyms, Abbreviations, Terms, And Definitions   What is RAD? Rapid Application Development (RAD) is a type of incremental software development methodology, which emphasizes rapid prototyping and iterative delivery, rather than planning. In RAD model the components or major functions are developed in parallel as if they were small relatively independent projects, until integration. RAD projects … Continue reading Software Development Life Cycle – What is RAD?

What is a Peer Review?

Acronyms, Abbreviations, Terms, And Definitions A peer review is an examination of a Software Development Life Cycle (SDLC) work product by team members, other than the work Product’s author, to identify defects, omissions, and compliance to standards.  This process provides an opportunity for quality assurance, knowledge sharing, and product improvement early during the SDLC life … Continue reading What is a Peer Review?