Monster Dimension
2 posters
Page 1 of 1
Monster Dimension
Hello All,
I have a monster customer dimension. around 50 million records in the initial load and a million record updates and new records daily. how should i manage it and make it more efficient. can table partitioning help me in this scenario like for fact tables? should i be dropping indexes before load and recreating them?
Really appreciate your help.
Thanks,
Syed
I have a monster customer dimension. around 50 million records in the initial load and a million record updates and new records daily. how should i manage it and make it more efficient. can table partitioning help me in this scenario like for fact tables? should i be dropping indexes before load and recreating them?
Really appreciate your help.
Thanks,
Syed
eshtee- Posts : 6
Join date : 2011-07-19
Re: Monster Dimension
Please refer to this post: http://forum.kimballgroup.com/t1177-scd-type-2-on-large-and-wide-dimension-tables#5287
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Similar topics
» Monster Dimensions
» Rapidly changing Monster dimension...
» Monster dimension, joining fact tables
» Monster Dimensions?
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» Rapidly changing Monster dimension...
» Monster dimension, joining fact tables
» Monster Dimensions?
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|