Building the Data Warehouse

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


■    Is there a delta file?


■    Are there system logs/audit logs that can be used?


■    Can existing source code and data structure be changed to create a delta file?


■    Do before and after image files have to be rubbed together?


■    How do I store the output, once scanned?


■    Is the DSS data preallocated, preformatted?


■    Is data appended?


■    Is data replaced?


■    Are updates in the DSS environment made?


The output from this step is the actual program specifications that will be used to bring data over from the operational environment to the data warehouse.


PARAMETERS OF SUCCESS: When properly done, this step allows the extract and integration of data to be done as efficiently and as simply as possible. (Seldom is this a smooth, simple process.)


DSS9—Programming


PRECEDING ACTIVITY: Specification.


FOLLOWING ACTIVITY: Population.


TIME ESTIMATE: One week per extract/integration program.


NORMALLY EXECUTED ONCE OR MULTIPLE TIMES: Once per program.


DELIVERABLE: Extract, integration, time-perspective program transformation.


This step includes all the standard activities of programming, such as the following:


■■ Development of pseudocode ■■ Coding ■■ Compilation ■■ Walkthroughs


■    Testing-unit, stress-in its many forms


PARAMETERS OF SUCCESS: When done properly, code that is generated out of this step is efficient, documented, able to be changed easily, accurate, and complete.


DSS10—Population


PRECEDING ACTIVITY: Programming; technical environment preparation. FOLLOWING ACTIVITY: Usage of the data warehouse.


TIME ESTIMATE: NA

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