Derived Data or Pre-calculated data - Definition & meaning

PDF
Derived data is produced by applying calculations to input data at the time the request for that data is made, i.e., the data has not been pre-computed and stored on the database. The purpose of using derived data is to save storage space and calculation time, particularly for calculated data that may be infrequently called for or that is susceptible to a high degree of interactive personalization by the user. The tradeoff is slower retrievals.
 
Home OLAP Jargons Derived Data or Pre-calculated data - Definition & meaning

BI & DW - Interview questions | Insomnia articles | Job interview questions with answers