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.