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

Monster Dimension

2 posters

Go down

Monster Dimension Empty Monster Dimension

Post  eshtee Thu Jul 28, 2011 12:19 am

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.



Posts : 6
Join date : 2011-07-19

Back to top Go down

Monster Dimension Empty Re: Monster Dimension

Post  hang Thu Jul 28, 2011 1:02 am

Please refer to this post:


Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Back to top

- Similar topics

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