Hacker News new | ask | show | jobs
by pratikpatel 5448 days ago
The last stage of enterprise integration with the DW is through Data Marts, which are organized into Dimensions and Facts, and allow for dynamic interfaces for business users to mine their data. My current project is using Informatica CDC (Change Data Capture) to read multiple source databases through their logs and aggregate in real-time. Its really incredible and enables any level of intricate reporting requirements.
1 comments

The article talks about Informatica as an ETL tool provider... I wouldn't agree it's the "last stage" either, ETL is critical to any (E)DW.