What is a staging table?

问题:

Are staging tables used only in Data warehouse project or in any SSIS Project? I would like to know what is a staging table? Can anyone give me some examples on how to use it and in what circumstances it is implemented? Also, may I please know the best practices while using it?

回答1:

staging tables are just database tables containing your business data in some form or other. Staging is the process of preparing your business data, usually taken from some business application. For your average BI system you have to prepare the data before loading it. A staging table is essentially just a temporary table containing the business data, modified and/or cleaned. Depending on your actual case you may have several staging tables from different source systems that then are combined into the resulting fact table for the BI system.