Modelling custom extension fields

View previous topic View next topic Go down

Modelling custom extension fields

Post  purushsimhan on 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

View user profile

Back to top Go down

Re: Modelling custom extension fields

Post  Abhiraizada on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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