Data warehouse requirements documents: There are two documents: a metrics
document and a quality document. The metrics document specifies, for each
quality dimension, the range of values that are acceptable for each attribute
involved in a requirement, and the metrics to be used in the data warehouse
design. The quality document specifies the range of values acceptable for each
requirement. For each required attribute, the document defines (1) maximum
time for data loading; (2) minimum value for data currency (i.e., the age of
the data); and (3) acceptable values for consistency and completeness. For
each dimension, the report includes the formula for obtaining maximum or
minimum values.
??? Preliminary.data.model: With the collected information building a preliminary
version of the star schema model for the data warehouse is straightforward.
??? Data. source. requirements. document:.With the information obtained in
Phase IV a document containing the data sources is produced. This document
contains for each data source an identifier, a description, and the data source
availability.
??? ETL.process.requirements.document: A complete listing of the required
data and a mapping from the required data to the data source fields from which
these data are obtained is provided, possibly including formulas involving
more than one data field.
Pages:
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181