Loading data in Data Warehouse

Go down

Loading data in Data Warehouse Empty Loading data in Data Warehouse

Post  piyushtamaskar21 on Sun Mar 16, 2014 11:37 pm

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?

piyushtamaskar21

Posts : 2
Join date : 2014-03-16

Back to top Go down

Loading data in Data Warehouse Empty Re: Loading data in Data Warehouse

Post  nick_white on Wed Apr 23, 2014 2:39 am

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

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Back to top


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