Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is a Staging table ? Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 4:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 2:51 AM
Points: 41, Visits: 227
What is a Staging table ?
How to use it ?
And When is it advised to use Staging tables

Regards,
Arjun
Post #1437794
Posted Tuesday, April 2, 2013 4:31 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:08 AM
Points: 708, Visits: 3,286
writearjun53 (4/2/2013)
What is a Staging table ?
How to use it ?
And When is it advised to use Staging tables

Regards,
Arjun


What is a Staging table ?

A staging table is just a regular SQL server table. For example, if you have a process that imports some data from say .CSV files then you put this data in a staging table. You may then decide to apply some data cleaning or business rules to the data and move it to a different staging tables etc...

How to use it ?

Like any other SQL Server table!

And When is it advised to use Staging tables

Use it when you need it! I gave an example above when importing data or when moving data between servers etc..


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1437817
Posted Tuesday, April 2, 2013 5:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:28 AM
Points: 102, Visits: 1,050
Staging table is used in importing data from some other datasource into SQL.

During import,we need process some derived column or data conversion transformation then we will load into to the destination sql tables.


Regards,
Kumar
Post #1437821
Posted Tuesday, April 2, 2013 5:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
staging table is Sql table only.

consider below eg.

if we having table A on database A
n having same table on database B..
here i m using database B for datawarehouse..

so in this we can called table A on database B is staging..

Post #1437824
Posted Tuesday, April 2, 2013 5:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
Hemant.R (4/2/2013)
staging table is Sql table only.

consider below eg.

if we having table A on database A
n having same table on database B..
here i m using database B for datawarehouse..

so in this we can called table A on database B is staging..



and why is the table B is called staging , why not A ?



~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1437836
Posted Tuesday, April 2, 2013 6:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:09 AM
Points: 870, Visits: 2,385
A Staging table is used to land data from outside of the current system, be it from another database, spread sheet, MS Access or anything else.

Its forms an interface contract between the source data and the destination database, so that it is isolated as much as possible from downstream changes, or when there are material changes it goes bang during the move of the data, eg Change in datatype, removal of column etc.

It also gives the benefit that you can get the data very quickly from the source lift it over to the Staging table, then commence work on it, where a transformation could take 20 minutes, which is perfect when your source system is operational 24/7.


_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1437848
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse