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

Hundreds of columns in a flattenned dimensional hierarchy

2 posters

Go down

Hundreds of columns in a flattenned dimensional hierarchy Empty Hundreds of columns in a flattenned dimensional hierarchy

Post  Duaneep Wed Jul 17, 2013 11:43 pm

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

Duaneep

Posts : 2
Join date : 2013-07-17

Back to top Go down

Hundreds of columns in a flattenned dimensional hierarchy Empty Re: Hundreds of columns in a flattenned dimensional hierarchy

Post  sachij3u Thu Jul 18, 2013 12:17 pm

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
sachij3u

Posts : 19
Join date : 2013-07-11
Age : 43
Location : Herndon, VA

Back to top Go down

Hundreds of columns in a flattenned dimensional hierarchy Empty Re: Hundreds of columns in a flattenned dimensional hierarchy

Post  Duaneep Thu Jul 18, 2013 3:35 pm

Thanks. I'll give it a go like that.

Duaneep

Posts : 2
Join date : 2013-07-17

Back to top Go down

Hundreds of columns in a flattenned dimensional hierarchy Empty Re: Hundreds of columns in a flattenned dimensional hierarchy

Post  sachij3u Thu Jul 18, 2013 4:28 pm

Pls let me know how it worked in Prod.
sachij3u
sachij3u

Posts : 19
Join date : 2013-07-11
Age : 43
Location : Herndon, VA

Back to top Go down

Hundreds of columns in a flattenned dimensional hierarchy Empty Re: Hundreds of columns in a flattenned dimensional hierarchy

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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