A few are ....
- Cognos Decision Stream
- Oracle Warehouse Builder
- Business Objects XI (Extreme Insight)
- SAP Business Warehouse
- SAS Enterprise ETL Server
The Latest Version is 7.2
PowerCenter - ability to organize repositiries into a data mart domain and share metadata across repositiries.
PowerMart - only local repositiry can be created.
Sequence Generator Transformation
Stored Procedure Transformation
Update Strategy Transformation
XML Source Qualifier Transformation
Advanced External Procedure Transformation
ODS - Operational Data Store.
ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity.
Once data was poopulated in ODS aggregated data will be loaded into into EDW through ODS.