Modelling custom extension fields
2 posters
Page 1 of 1
Modelling custom extension fields
Hi,
Need help /advise on dimensional modelling.
Ours is SAAS based DWH model. For all the customers use same STAR for their analysis. Data in the fact and dimension is split horizontally using partitions. there are some dimension tables which is fixed that is my source and target is known. Some of the dimension populated based on the customer configuration in the OLTP system. These are custom dimensons. In my DWH we have defined say 50 custom dimensions. Not every customer is going to use all the 50 dimensions. Some may usse 5 and some may use 10 etc.
Can i Create one single star by linking all the possible dimension or to have different STAR for each customers. Please advise.
thanks
Need help /advise on dimensional modelling.
Ours is SAAS based DWH model. For all the customers use same STAR for their analysis. Data in the fact and dimension is split horizontally using partitions. there are some dimension tables which is fixed that is my source and target is known. Some of the dimension populated based on the customer configuration in the OLTP system. These are custom dimensons. In my DWH we have defined say 50 custom dimensions. Not every customer is going to use all the 50 dimensions. Some may usse 5 and some may use 10 etc.
Can i Create one single star by linking all the possible dimension or to have different STAR for each customers. Please advise.
thanks
purushsimhan- Posts : 1
Join date : 2009-09-29
Re: Modelling custom extension fields
Do you mean, you will have common fact tables (which will be used by all customers) but the dimension tables depends upon customer need ?
Or are you planning to build separate star or customized star on top of your DWH based on customer need ?
Regards,
Abhiraizada
Or are you planning to build separate star or customized star on top of your DWH based on customer need ?
Regards,
Abhiraizada
Abhiraizada- Posts : 20
Join date : 2011-05-24
Similar topics
» How best to allow for future custom facts and dimensions while defining a new star schema
» Dimension fields depend on other fields
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» How to populate custom fact table with core facts
» Custom Build VS Product driven data warehouse
» Dimension fields depend on other fields
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» How to populate custom fact table with core facts
» Custom Build VS Product driven data warehouse
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|