Push or Pull into the Data Warehouse

Go down

Push or Pull into the Data Warehouse

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


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?



Posts : 39
Join date : 2011-02-25

View user profile

Back to top Go down

Back to top

- Similar topics

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