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
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
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Search
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"






