什么是临时表? [英] What is a staging table?

问题描述

暂存表是否仅用于数据仓库项目或任何SSIS 项目?我想知道什么是临时表?谁能给我一些关于如何使用它以及在什么情况下实施它的例子?另外，我可以知道使用它时的最佳做法吗?

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?

推荐答案

临时表只是包含某种形式的业务数据的数据库表.暂存是准备业务数据的过程，通常取自某些业务应用程序.对于普通的 BI 系统，您必须在加载数据之前准备好数据.临时表本质上只是一个包含已修改和/或清理过的业务数据的临时表.根据您的实际情况，您可能有多个来自不同源系统的临时表，然后将它们组合到 BI 系统的结果事实表中.

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.

这篇关于什么是临时表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！