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?

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