Use as many dimensions as possible for performance improvement; for example assume that you have 100 products and 200 customers; if you make one dimension for both, the size of the dimension will be 20,000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characteristic per dimension, do the math considering worst case scenario and decide which characteristics may be combined in a dimension.
No comments:
Post a Comment