The slowly-changing-dimension tag has no wiki summary.
0
votes
2answers
322 views
How to build dimensions from SCD tables
Having the foresight to begin collecting data from our production environment several years ago, I have a table with a following structure-
Part
Status
Startdate
Enddate
I can write a relational ...
2
votes
1answer
925 views
SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
Here is an example picture of my layout.
As you can see I have my SCD types present (status/startdate/enddate/businesskey).
My key is a surrogate key that identifies each record.
My problem is ...
4
votes
1answer
225 views
Dimension Help - Deciding Fact or Dimension
We have the following Dim and Facts:
Customer Dim: SCD Type 2, Info about the customer ie first purchase date, name, address, etc
Product Dim: SCD Type 2, about our products
Customer Snapshot ...
