Database Reference
In-Depth Information
Figure 2.11
Package PKG_LoopAndLoad.
Figure 2.12
Years dimension before PKG_LoopAndLoad.
Figure 2.13
Years dimension after PKG_LoopAndLoad.
8. vAr_kounter increments itself by 1, and tests to see if it is equal to vAr_
maxDimCount. If the values match, the flow branches to vAr_Status, if not,
vAr_LoopDimname refreshes again.
9. When all of the dimensions in vDimList have been looped, ProC_
LogheaderFooter writes an end message to LoadStatus.
using the examples of data orphans in the years dimension, FigureĀ 2.12 shows the
years dimension before Pkg_LoopAndLoad is run.
FigureĀ 2.13 shows the years dimension after Pkg_LoopAndLoad is executed with
orphan members loaded under the parent Suspendyears, thus ensuring that the fact
data rows that contain years 1911 and next year can be loaded to ASosamp.