I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time better than adding them during the overnight data warehouse update? Our data warehouse is small. How should I go about maintenance of this table?
September 9, 2008 7:56 PM
September 20, 2008 10:06 PM