Loading data in Data Warehouse
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
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|