ETL development - best practices

• Shurkadze

  SSC Eights!

  Points: 942

  More actions

  July 13, 2011 at 11:31 am

  #244290

  Hi I am developing a number of ETL processes for a data warehouse to move data from transactional DB to the data warehouse.

  I am using stored procedures - one per destination table.

  What is the best practice to have stored procedures in transactional DB or the data warehouse?

  Are there any advantages of one over the other?

  Thanks, Alexander.

• Mike01

  SSChampion

  Points: 11420

  More actions

  July 13, 2011 at 11:35 am

  #1352324

  what are you using the SPs for? Usually these are used to retrieve the data. If so, then the source DB would be the place.

  For better, quicker answers, 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/