dimensional-modeling Archives

Should I create a Factless Fact Table or Denormalise my table

By adminPosted on September 22, 2022

Question : I am creating a data warehouse from a store database and I have a question regarding the design […]

By adminPosted on August 29, 2022

Question : I am working on a project to create a series of tables that are easier to use and […]

By adminPosted on June 12, 2022

Question : I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star […]

By adminPosted on May 11, 2022

Question : For a web application whose sole purpose is to allow users to upload raw file data at any […]

By adminPosted on January 11, 2022

Question : I’m looking for a some guidance/advice on how to best model my data. Some background: I have location […]

By adminPosted on December 3, 2021

Question : I am a beginner trying to understand the basic concepts of database’s. I know several types of keys […]

By adminPosted on November 12, 2021

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

By adminPosted on May 3, 2021

Question : I am taking a course on data warehousing. Currently, I am reading through Ralph Kimball’s Data Warehouse Toolkit. […]

By adminPosted on March 19, 2021

Question : I’m trying to design a star-schema fact table along with some dimension tables that will surround it. If […]

By adminPosted on March 11, 2021

Question : I’ve been reading about dimensional models, and in particular fact tables, but I haven’t really seen one in […]