Approaches to Handling Standalone Derived Data - Teradata Database

Approaches to Handling Standalone Derived Data

There are occasions when you might want to denormalize standalone calculations for performance reasons. Base the decision to denormalize on the following demographic information, all of which is derived through the ATM process described in Chapter 6: “The Activity Transaction Modeling Process”:

Number of tables and rows involved

Access frequency

Data volatility

Data change schedule