Question on Multiple stage databases

View previous topic View next topic Go down

Question on Multiple stage databases

Post  mru22 on Fri Feb 15, 2013 5:09 pm

We have a project that will have to pull data from a few external sources. Some of these sources might eventually be used in other data warehouse projects and some of the soruces
may have identical table names but different schemas'

I was wondering if it makes more sense to have separate stage databases that mimic the OLTP systems or just have one stage database with all of the tables from all systems. If I go with one database then there is the possiblity that we could have two tables that represent the same thing with different schemas.

I was leaning toward separate stage databases and assumed over time if the number of tables grow it might be logically easier to maintain the separate stage databases.
But I am reltively new to ETL design and wasn't sure if there were other things I should consider.

Any thoughts are appreciated and welcome.

Thanks,

mru22

Posts : 34
Join date : 2011-06-14

View user profile

Back to top Go down

Re: Question on Multiple stage databases

Post  ngalemmo on Fri Feb 15, 2013 6:31 pm

I don't think it matters much one way or the other. Do what suits your environment.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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