Monster Dimension

[eshtee]

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

[hang]

Please refer to this post: http://forum.kimballgroup.com/t1177-scd-type-2-on-large-and-wide-dimension-tables#5287