Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


Have instructions been prepared, tested, and written? Have these instructions been kept up-to-date?


27.    What level of preparation is there for reorganization/restructuring of:


■    Operations?


■    Systems support?


■    Applications programming?


■■ The DBA?


■■ The DA?


Have written instructions and procedures been set and tested? Are they up-to-date? Will they be kept up-to-date?


ISSUE: (See issues for question 26.)


28.    What level of preparation is there for the loading of a database table by:


■    Operations?


■    Systems support?


■    Applications programming?


—    The DBA?


—    The DA?


Have written instructions and procedures been made and tested? Are they up-to-date? Will they be kept up-to-date?


ISSUE: The time and resources for loading can be considerable. This estimate needs to be made carefully and early in the development life cycle.


29.    What level of preparation is there for the loading of a database index by:


■■ Operations?


■■ Systems support?


■■ Applications programming?


■■ The DBA?


■■ The DA?


ISSUE: (See issue for question 28.)


30.    If there is ever a controversy as to the accuracy of a piece of data in the data warehouse environment, how will the conflict be resolved? Has ownership (or at least source identification) been done for each unit of data in the data warehouse environment? Will ownership be able to be established if the need arises? Who will address the issues of ownership? Who will be the final authority as to the issues of ownership?

Скачать в pdf «Building the Data Warehouse»