View Single Post
  #14 (permalink)  
Old October 12th, 2010, 05:56 AM
AndreV AndreV is offline
Registered User
Join Date: Jul 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

To import the FactSalesQuota table you will probably need to make sure that the id column on the table isn't included in the import.

This is because these values are uniques identifiers and therefore don't compress - making the size of the imported data much larger. You don't need these columns and they shouldn't really be on the source database anyway as they serve no real purpose. You can do the same for all the fact tables in those sample dbs.

Hope that helps.