Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Modelling Heterogeneous Product table

3 posters

Go down

Modelling Heterogeneous Product table Empty Modelling Heterogeneous Product table

Post  dcow Fri Mar 05, 2010 6:29 am

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?

dcow

Posts : 5
Join date : 2009-09-03

Back to top Go down

Modelling Heterogeneous Product table Empty Re: Modelling Heterogeneous Product table

Post  ngalemmo Fri Mar 05, 2010 12:35 pm

Yes.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Modelling Heterogeneous Product table Empty Re: Modelling Heterogeneous Product table

Post  DilMustafa Tue Mar 09, 2010 12:24 pm

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

Back to top Go down

Modelling Heterogeneous Product table Empty Re: Modelling Heterogeneous Product table

Post  dcow Tue Mar 09, 2010 8:54 pm

That is Exactly the way i see it would happen

dcow

Posts : 5
Join date : 2009-09-03

Back to top Go down

Modelling Heterogeneous Product table Empty Re: Modelling Heterogeneous Product table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum