Question on Multiple stage databases
2 posters
Page 1 of 1
Question on Multiple stage databases
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,
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
Re: Question on Multiple stage databases
I don't think it matters much one way or the other. Do what suits your environment.
Similar topics
» Surrogate Key in Stage table
» Question on Multiple fact table design
» Multiple measures in a fact table- modelling question
» Design Question - Multiple Fact Tables at the same Grain
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Question on Multiple fact table design
» Multiple measures in a fact table- modelling question
» Design Question - Multiple Fact Tables at the same Grain
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum