Revenue Fact Staging Table
A common staging table is used during ETL to populate both:
-
Project Revenue Line Fact (W_PROJ_REVENUE_LINE_F)
-
Project Revenue Header Fact (W_PROJ_REVENUE_HDR_F)
This staging process ensures consistent loading of both fact tables.