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.

Thanks,
Syed

eshtee

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: 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

Back to top Go down

Back to top

- Similar topics

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