Re: DB Design - Architecture Question.

AnGanesh wrote:
> We are planning to have a generic database
That doesn't sound good...

> Whenever, the source DB is populated we would like to have the
> GENERIC_TBL1 in generic schema populated with the data at real time.
And that sounds like a real time data warehouse.

So here is a good article on generic databases: http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/

Here is an intro to RTDW:
http://www.dbazine.com/datawarehouse/dw-articles/rittman5

And here is some info about connecting to SQL Server: http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96544/gencon.htm

-- 
Michal Kuratczyk