Loading data in Data Warehouse

View previous topic View next topic Go down

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

View user profile

Back to top Go down

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 : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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