Building the Data Warehouse

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


ISSUE: From time to time, the data model needs to be updated to reflect changing business needs of the organization. As a rule, these changes are incremental in nature. It is very unusual to have a revolutionary change. There needs to be an assessment of the impact of these changes on both existing data warehouse data and planned data warehouse data.


8.    Has the operational system of record been identified?


■    Has the source for every attribute been identified?


■    Have the conditions under which one attribute or another will be the source been identified?


■■ If there is no source for an attribute, have default values been identified?


■■ Has a common measure of attribute values been identified for those data attributes in the data warehouse environment?


■■ Has a common encoding structure been identified for those attributes in the data warehouse environment?


■    Has a common key structure in the data warehouse environment been identified? Where the system of record key does not meet the conditions for the DSS key structure, has a conversion path been identified?


■    If data comes from multiple sources, has the logic to determine the appropriate value been identified?


■    Has the technology that houses the system of record been identified?


■    Will any attribute have to be summarized on entering the data warehouse?


■    Will multiple attributes have to be aggregated on entering the data warehouse?


■    Will data have to be resequenced on passing into the data warehouse?

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