Data Maintenance
So far we have built a simple BW system and loaded data into it. Now suppose the business has changed, so that the characteristic data will change as well. If we modify the characteristic data, what will happen to the InfoCube, aggregate, and ODS object data that depend on the characteristic data? In this chapter we will answer this question and several others:
- How do we delete InfoCube data?
- How do we maintain indices and statistics?
- How do we manage individual data load requests?
- How do we automate aggregate rollup?
- Can we compress multiple data load requests into one request? How?
We start from the first question, how to deal with changed characteristic data.