Push or Pull into the Data Warehouse

View previous topic View next topic Go down

Push or Pull into the Data Warehouse

Post  min.emerg on Wed Oct 17, 2012 8:52 am

Hello

I have been looking for references to best practices related to which part of the system is responsible for loading the data warehouse. In the past I added to the staging database the SQL stored procedures for transforming the source data and loading the warehouse. As such, the staging database would push updates to the data warehouse database. It's also easy enough to have these scripts as part of the data warehouse database, and have them pull and transform data from the staging database.

Is one approach better than the other? Are there any best practice that advise on either approach?

Thanks.

min.emerg

Posts : 39
Join date : 2011-02-25

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum