Re: Extracting from the Warehouse

Hi Wreck,
the most basic advice is OLTP happens in OLTP systems and BI happens of
ODS/EDW systems.....there can be some update in ODS/EDW but it is a
mistake to do too much..

So, if your web app is mostly query with little update having one set
of ETL would make a good idea...if it is mostly update you should write
it like an OLTP system and pass data to/from the OLTP systems and then
forward it onto the ODS/EDW.

You are correct in thinking that writing two lots of ETL is a bad
idea....ETL is easily the most people expensive portion of a BI
project...

Best Regards
Peter
www.peternolan.com

.

Loading