What is a staging table?

ssis etl data-warehouse staging-table
Suj picture Suj · Mar 28, 2015 · Viewed 38.3k times · Source

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?

Answer

Dirk Trilsbeek picture Dirk Trilsbeek · Mar 28, 2015

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.

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:- for the destination I chose "SQL server native client 10". …

Read More
SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for Oracle and I am using this query: SELECT ID FROM Test I get an error message saying: the value cannot …

Read More