One of the most challenging aspects of large scale data warehouse development is the sheer immense size. It’s common to see all sorts of problems once the data warehouse gets larger. Common problems include performance degradation, out of storage space, long running queries, blocking and failure to keep up with data feeds. I have compiled a list of tips that help me to manage the size effectively over the years on terabyte DW projects. I hope they will be beneficial to you as well. Here we go: ...
|
1
kudos |
|
||||
No comments yet, be the first one to post comment.