Question : Myself and another DBA at our company are tasked with reviewing a database design that a vendor has […]
Tag: dimensional-modeling
Designing a dimensional DB off a normalized source that already implements SCD’s
Question : I have built an SSIS ETL to integrate various data sources (one from MySQL, two from SQL Server) […]
what is the difference between ‘order’ and ‘order line’?
Question : I was trying to understand degenerate dimensions. But I quite often encounters the term “order line” as grain […]
To normalize or not to normalize for few distinct values
Question : Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined […]
Should I create a Factless Fact Table or Denormalise my table
Question : I am creating a data warehouse from a store database and I have a question regarding the design […]
How to optimally structure a table with sparse data
Question : I am working on a project to create a series of tables that are easier to use and […]
Connecting dimension tables in a multi-fact star schema database warehouse?
Question : I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star […]
Transactional versus Dimensional model for file upload web application — preferred approach?
Question : For a web application whose sole purpose is to allow users to upload raw file data at any […]
Database model / design best practice
Question : I’m looking for a some guidance/advice on how to best model my data. Some background: I have location […]
What is the meaning of “dimension key”?
Question : I am a beginner trying to understand the basic concepts of database’s. I know several types of keys […]