Hundreds of columns in a flattenned dimensional hierarchy
2 posters
Page 1 of 1
Hundreds of columns in a flattenned dimensional hierarchy
Hi,
I have a fixed 5 level hierarchy of dimensions. To avoid snowflaking I'd normally push the upper levels down to the lowest. However, there are a lot of columns.
Level 1 - Top - 20
Level 2 - 40
Level 3 - 30
Level 4 - 150
Level 5 - 200
This would give a 440 column dimension. Is this ok, or a bit too much?
Thanks, Duane
I have a fixed 5 level hierarchy of dimensions. To avoid snowflaking I'd normally push the upper levels down to the lowest. However, there are a lot of columns.
Level 1 - Top - 20
Level 2 - 40
Level 3 - 30
Level 4 - 150
Level 5 - 200
This would give a 440 column dimension. Is this ok, or a bit too much?
Thanks, Duane
Duaneep- Posts : 2
Join date : 2013-07-17
Re: Hundreds of columns in a flattenned dimensional hierarchy
The # of columns seems to high but its still better than having a snowflake. I have worked on 250-300 attributes in financial DW tables.
sachij3u- Posts : 19
Join date : 2013-07-11
Age : 43
Location : Herndon, VA
Re: Hundreds of columns in a flattenned dimensional hierarchy
Thanks. I'll give it a go like that.
Duaneep- Posts : 2
Join date : 2013-07-17
Re: Hundreds of columns in a flattenned dimensional hierarchy
Pls let me know how it worked in Prod.
sachij3u- Posts : 19
Join date : 2013-07-11
Age : 43
Location : Herndon, VA
Similar topics
» Dimensional Design i healthcare business with hundreds of yes/no answers
» Dimensional Hierarchy
» How many columns is too many OR how to reduce the columns
» Fact with large columns, 320.
» SCD 2 Audit / Metadata Columns
» Dimensional Hierarchy
» How many columns is too many OR how to reduce the columns
» Fact with large columns, 320.
» SCD 2 Audit / Metadata Columns
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum