|
ETL Xpert
ETL Xpert provides a pre-packed, fully integrated data warehouse and ETL (Extract, Transform, Load) solution for Microsoft SQL Server 2005/2008. It's 100% based SQL Server components only.
Comparable shortest implementation time is given by its pre-configured modelling and load process approach.
Features- Generic, fully extensible data warehouse design with galaxy support where each dimension may serve as source to build
time-related fact snapshot objects - Full flexibility thru object and process driven metadata repository with distinction between logical and physical data layer and extensible with custom specialtasks
- Parallel process execution for best performance
- Conversion on demand for multi-attribute dimensions
into parent-child structures and vice-versa - Full support of slowly changing dimensions;
preserve historical hierarchy structures on demand
(incl late arriving dimension members and fact data)
|
Process Example
|
|
|
|
|
|
|
|
|
|
|
|
|
Metadata Repository
|
|
|
|
|
|
|
|
|
|
|
|
|