While business continuity and disaster recovery plans are important for all corporate applications, it is imperative that they exist for the most critical applications. The moment that these systems go down, your business is losing money. What are the different components of disaster recovery, and what should be in a good DR plan?
Surrogate keys are the way to go more than 90 percent of the time in data warehouses. However, that 10 percent of the time may kill you, especially if you are dealing with a heavily utilized attribute that is the natural primary key of a dimension which is very large.
Many companies are learning the consequence of poor data quality. Whether you deploy DQA tools or a business rules repository, the need to continuously ensure the high data quality has never been greater.
When implementing a data warehouse for the first time, most people do not perform essential rigorous performance testing prior to launching the warehouse.
Most organizations don't stop and really assess how well their data warehouse will support the purposes it is being targeted for. It is extremely important that all warehouses perform a yearly assessment to analyze the maturity of your data warehouse. Here's some help.
You may have designed your warehouse with scientific precision, but a number of factors such as the data loading process, query patterns and unexpected data volume growth can lead to performance degradation.
To properly estimate a data warehousing effort takes experience, a deep understanding of what is being built and pure gut feeling. There are numerous factors that impact the schedule on a data warehouse project. In this article, we'll discuss some of those factors and give you some guidelines for estimating the data warehousing effort.
Little thought is given to enhancing the data warehouse after production. But all of these areas would be given proper treatment during the initial warehouse development--if a clear process was followed.