Loading data in Data Warehouse
2 posters
Page 1 of 1
Loading data in Data Warehouse
Hi,
Can we load data in data warehouse ,if my staging tables are in one scema and my dw(Snowflake Schema) is in another schema but those two schemas are in same database..
Can we do that with SQL Procedure to load from Staging to DW? Or Do we have any solution other than this?
Can we load data in data warehouse ,if my staging tables are in one scema and my dw(Snowflake Schema) is in another schema but those two schemas are in same database..
Can we do that with SQL Procedure to load from Staging to DW? Or Do we have any solution other than this?
piyushtamaskar21- Posts : 2
Join date : 2014-03-16
Re: Loading data in Data Warehouse
Yes -as long as you fully qualify the name of any object (table, etc.) that you reference.
If they are in in different DBs you can still do this, you just need to set up DB links between the 2 DBs
If they are in in different DBs you can still do this, you just need to set up DB links between the 2 DBs
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
![-](https://2img.net/i/empty.gif)
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» difference between data mart and data warehouse at logical/physical level
» Anti-aliasing time series data in a data warehouse?
» Using the Dimensional Data Warehouse as source data for the OLTP process
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» difference between data mart and data warehouse at logical/physical level
» Anti-aliasing time series data in a data warehouse?
» Using the Dimensional Data Warehouse as source data for the OLTP process
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|