Heterogeneous Product Schema

mark.tan at 15h37
06
Oct
2009
Heterogeneous Product Schema

Hi,

I am reading the Heterogenous Product Schema chapter from Kimball. I am trying to understand the design technique. Am I correct to that if I have many different type of dissimilar product, my design will look like this?

Fact Table
========
Month_SID
Prod1_SID
Prod2_SID
...
Core Facts

Prod1 Dim Table
============
Prod1_SID
...
Prod1 Attribu
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Dear moderators and users, This is my first post here. I am involved in dimensional modeling of a manufacturing DW/BI project. I have the following scenario. Let me describe it here. The image above depicts a sample process flow in a factory; wit
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
Hello, I inherited a DataWarehouse with a hybrid Model. We have a Security dimension table (PK is SecurityId) that has several different types of securities (i.e stocks, bonds, cash). Each of these types of Securities has its own table with specific
Hi, I am a fresh student and I am trying to understand the Heterogeneous concept. I am wondering what the difference is between a Heterogenous schema and a regular schema. Why would someone use a heterogeneous vs a regular schema and when is it
I work with clinical health care data, which is very different in nature than the financial and transactional data common to the business world. Clinical data is extremely heterogeneous, with a high degree of dimensionality and less obvious “fact-ness”
Forums from same category
See also
more_less
Informations

14 Replies For the topic :
"Heterogeneous Product Schema"

This topic has been viewed 3505 times.

Last message :
06/10/2009 at 15h37 by "mark.tan"