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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!