page227
313
Figure 8-23.
Temporal load sample data
From the information presented in Figure 8-23, you can deduce the following:
•
The record date ranges are increasing through time with more future
dated records appearing and fewer older dated records.
•
The highest volume of new, changed, or deleted records occurs for
2023, 2024, 2025, and 2026.
•
The data is skewed; i.e., the records are not evenly distributed
according to date.
This segmentation approach must reflect the sample date ranges; therefore, our
segment ranges might look similar to Figure 8-24.
Figure 8-24.
Temporal load partitions
Not all partitions will contain equal date ranges to reflect the relative volume of
DML operations for the period. Note the focus on 2024 and 2025 where I suggest four
partitions matching each quarter year.
As the load data profile moves forward in time, you must periodically adjust the date
ranges for the partitions and remap the data loads to match. I suggest the maintenance is
conducted annually as an end of year activity.
Chapter 8
parallelization