Separate Staging Tables and Data Warehouse into different Databases.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 23, 2012 at 10:52 am

  #253084

  Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database.

  The Staging Tables are in a different schema than the Data Warehouse Tables.

  Maybe I'm missing something but I have to make a solid case that this is a good practice.

  Any information would be greatly appreciated.

  http://www.bidn.com/blogs/TomLannen/bidn-blog/1277/separating-data-warehouse-tables-from-your-relational-and-staging-tables

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 23, 2012 at 11:11 am

  #1463611

  Post moved to a more appropriate forum.

  http://www.sqlservercentral.com/Forums/Topic1271897-373-1.aspx

  Please do not post here.

  Thanks.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/