Push or Pull into the Data Warehouse
Page 1 of 1
Push or Pull into the Data Warehouse
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.
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
Similar topics
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» Only way to pull data from star/snowflake schema is by using facts?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
» difference between data mart and data warehouse at logical/physical level
» Only way to pull data from star/snowflake schema is by using facts?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» data warehouse and data warehouse system
» difference between data mart and data warehouse at logical/physical level
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|