Hi. I am thinking about the dimensions I created (and I use in a big BI project in production).


Kimball says "a dimension is a collection of attributes that are highly correlated with each other". I created more dimensions to facilitate the people's job. For example: There are six dimensions for paciente, like city and age.


Today we work with almost 100 tables and in my fact there are 68 dimension's foreign key.


Do you think I did a big mistake?


Thanks a lot! I am really thankful for your opinion!