Transaction files contain the main system data. They are generally large, and have a high turnover. They may well require frequent archiving.
Certain reference data will attach to each transaction. Consider whether the historic or the current view, or both, is relevant in subsequent interrogation. For example, does the sales manager need sales reported by the customer’s representative at the time of the sale, or by the customer’s current representative? In the former case, the representative must attach to the transaction; in the latter case, it should not.
Consider the latency of the data. A sales invoice record is current only so long as it is outstanding, however, the same data may be required for sales analysis over a much wider time span. The same data thus services two different information needs.
|
Copyright © 2014 CA.
All rights reserved.
|
|