ETL Tool Vs SOA
526620May 20 2011 — edited Nov 25 2012Hello Experts,
I would like to seek your valuable advice on following..
One vendor is proposing a BI/DW solution in which he has replaced the entire ETL tool (ex OWB) by building a solution using SOA technology. Following advantages are proposed for this solution.
1. It will be llight weight. ETL tool is having big footprint.
2. Cost effective since no ETL tool is involved.
3. Efficient data transfer as it will be online. (not based on a schedule with bulk-load like an ETL run during night time.)
My queries are
1. Whether anyone has worked/seen such design in BI/DW system.
2. Will the online extract degrage the perfomance of source system.
3. Whether such design will consider the use of surrogate keys. Late arriving fact entries. Conform dimensions.
4. Will it land up in an ODS rather than a data warehouse.
Please comment.
~ Ash