Staging Tables
Staging tables are used in the transformation of raw data into a star schema format. They are temporary storage.
This slide is an examples of a Track Back Diagram.
From left to right:
The two source tables shown in this diagram are ac_mstr and code_mstr. Note that the boxes are in green, there are outside the data Warehouse.
The source tables feed the load tables. The load tables are combined to a single stage table. Finally, we see that the stage table feeds the account dimension table.