Facts that require special staging tables and ETLs
For most fact tables, the process to load the stored data to calculate metrics is simple. However, some fact tables require special staging tables, and ETLs to assist with the loading process.
The following table shows
the facts that require special
staging tables and ETLs:
- Financial Summary
- triFinancialSummary
- Standard Hours
- triStandardHours
- Standard Hours Details
- triStandardHoursDetails
- Asset Analytic Hourly Fact
- triAssetAnalyticHFact
- Asset Energy Use Daily Fact
- triAssetEnergyUseDFact
- Asset Energy Use Hourly Fact
- triAssetEnergyUseHFact
- Asset Energy Use Monthly Fact
- triAssetEnergyUseMFact