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

Modelling custom extension fields

Go down

Modelling custom extension fields Empty Modelling custom extension fields

Post  purushsimhan Fri Jan 06, 2012 2:21 am

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







purushsimhan

Posts : 1
Join date : 2009-09-29

Back to top Go down

Modelling custom extension fields Empty Re: Modelling custom extension fields

Post  Abhiraizada Tue Jan 17, 2012 4:32 am

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

Abhiraizada

Posts : 20
Join date : 2011-05-24

Back to top Go down

Back to top


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