Question : I have a requirement to store data about a load of Searches. Each time someone searches we want […]
Tag: slowly-changing-dimension
Do I have the right Slowly Changing Dimensions type for my version controlled tennis match database?
Question : I’m trying to version control my database using the principles of Slowly Changing Dimensions. I’ve opted to use […]
Join Fact table to SCD Type 2 … how to write query? (SQL Server)
Question : I can’t seem to find this simple fact anywhere. I have a fact table like such in SQL […]
How to create a view with added rows for missing dates?
Question : I’m not sure how to accurately phrase this question. Essentially, say I have a bunch of salespeople on […]
History table implementation: “Tuple-versioning” vs Effective Date
Question : I’m designing a database that will have history tables (SCD Type 4 I guess) for auditing purpose. The […]
How to deal with fact table data that needs to be version controlled?
Question : I have the following simplified sport_match ‘fact’ table: match_id tournament_id player_id_p1 player_id_p2 p1_final_score p2_final_score 1 1 1 2 […]
SSIS: Slowly changing dimension with lists (one-to-many relationship)
Question : Slowly changing dimension (specifically type 2) is a brilliant concept for being able to keep historical periodic (e.g. […]
Are duplicated NVARCHAR values stored as copies in SQL Server?
Question : I’m designing a table that will contain a lot of rows. So need to be careful not to […]
Dimension Help – Deciding Fact or Dimension
Question : We have the following Dim and Facts: Customer Dim: SCD Type 2, Info about the customer ie first […]
Data Warehouse – Slowly Changing Dimensions with Many to Many Relationships
Question : As an example, let’s say I have a fact table with two dimensions and one measure FactMoney table […]