Avoiding snowflakes
2 posters
Page 1 of 1
Avoiding snowflakes
Thanks everyone for their input in these forums, I have been able to answer many of my questions by just browsing what's already there.
However, I'm a bit stuck on this one.
I have a Patient dimension, which contains information like
- URNumber (business key)
- Title
- Surname
- GivenName
- DateOfBirth
- MedicareNumber
- Address
I also want to add the following information, but I already have a Location dimension containing this hierarchy
- PostCode
- Suburb
- StatisticalLocalArea
- LocalGovernmentArea
- ResidentialRegion
- State
- Country
Should I replicate this information in the Patient dimension, or snowflake from the Patient dimension to my Location dimension ?
Thanks in advance
Regards
Steve
However, I'm a bit stuck on this one.
I have a Patient dimension, which contains information like
- URNumber (business key)
- Title
- Surname
- GivenName
- DateOfBirth
- MedicareNumber
- Address
I also want to add the following information, but I already have a Location dimension containing this hierarchy
- PostCode
- Suburb
- StatisticalLocalArea
- LocalGovernmentArea
- ResidentialRegion
- State
- Country
Should I replicate this information in the Patient dimension, or snowflake from the Patient dimension to my Location dimension ?
Thanks in advance
Regards
Steve
hirths- Posts : 4
Join date : 2011-02-07
Re: Avoiding snowflakes
Thanks ngalemmo for your reply.
Could be a number of facts, Admission would be one of them.
I would need to keep the Location business key components (postcode/suburb) in the Patient dimension as a Type 2 SCD.
Then put something like PatientLocationID at time of Admission in the Admission fact.
Does that sound sensible ? I'm having trouble letting go of 20+ years on 3NF !!
Thanks
Steve
Could be a number of facts, Admission would be one of them.
I would need to keep the Location business key components (postcode/suburb) in the Patient dimension as a Type 2 SCD.
Then put something like PatientLocationID at time of Admission in the Admission fact.
Does that sound sensible ? I'm having trouble letting go of 20+ years on 3NF !!
Thanks
Steve
hirths- Posts : 4
Join date : 2011-02-07
Similar topics
» Too many Snowflakes or Outriggers?
» snowflakes and ORACLE partitions
» "A Trio of Interesting Snowflakes" article
» Avoiding Nulls in Dimension Tables
» Fact and dimension tables - avoiding same number of rows in both
» snowflakes and ORACLE partitions
» "A Trio of Interesting Snowflakes" article
» Avoiding Nulls in Dimension Tables
» Fact and dimension tables - avoiding same number of rows in both
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum