Modelling Heterogeneous Product table
3 posters
Page 1 of 1
Modelling Heterogeneous Product table
My Modelling of products has led me to a Heterogeneous Product situation
such that if have 10 Product , we
have 11 Product dimensions: 1 simplified dimension describing all the productsand 10
extended dimensions describing the custom products.
The design is something like below
CoreProduct Dimension
ProductKEY IDENTITY INT
ProductType
..Common Attributes
ProductTypeA Dimension
ProductKey FK
..specific Attributes
ProductTypeB Dimension
ProductKey FK
.. Custom specific Attributes
The Problem i am encountering is how to handle SCD2 changes within the Custom product dimension. From what i can see this sort of design woul result in a row needing to be aadded to the Core product table. Am i on the right track here?
such that if have 10 Product , we
have 11 Product dimensions: 1 simplified dimension describing all the productsand 10
extended dimensions describing the custom products.
The design is something like below
CoreProduct Dimension
ProductKEY IDENTITY INT
ProductType
..Common Attributes
ProductTypeA Dimension
ProductKey FK
..specific Attributes
ProductTypeB Dimension
ProductKey FK
.. Custom specific Attributes
The Problem i am encountering is how to handle SCD2 changes within the Custom product dimension. From what i can see this sort of design woul result in a row needing to be aadded to the Core product table. Am i on the right track here?
dcow- Posts : 5
Join date : 2009-09-03
Re: Modelling Heterogeneous Product table
What if the change is in sub dimension? Will I create two new records one in the main and one in the sub dimension.
DilMustafa- Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada
Re: Modelling Heterogeneous Product table
That is Exactly the way i see it would happen
dcow- Posts : 5
Join date : 2009-09-03
Similar topics
» Sparse Product Dim vs Heterogeneous Product Dim
» Heterogeneous Product Schema
» Applying the concept of heterogeneous product schema in manufacturing & supply chain
» Product and account dim FK in fact table
» Modelling Sales of Products and Product Packs
» Heterogeneous Product Schema
» Applying the concept of heterogeneous product schema in manufacturing & supply chain
» Product and account dim FK in fact table
» Modelling Sales of Products and Product Packs
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum