Leading Technology and Services Conglomerate, USA

1. Leading Technology and Services Conglomerate, USA GE Informatica-Business Objects Data Mart Consolidation Business Situation Business Benefits • Consolidate the independent HR data marts into the EDW • Need to save on the storage and server environment, and unwanted data movements • Saving in hard disk space by eliminating redundant tables • Integrated database server • Enriched Audit information • Easier maintenance as all coding was moved to Informatica • Manual processes involved ETL was automated • Common semantic layer definition with Integrated security Solution • Assessment of the existing Datamart and the EDW data models, ETL process and the Reporting • The infrastructure server utilization information was gathered • The delivery included integrated semantic layer, consolidated ETL process and an integrated data model • Used Hexaware tools for Semantic Layer consolidation and assessment of the ETL environment complexity Statistics • BI Team Size : 7 members • Over 40 Informatica mappings were developed • Consolidated 676 objects in BO Semantic Layer. • Optimized the effective disk space by 30% Technologies • OLAP Tools – Business Objects • ETL Tools – Informatica 8.6 • Databases – Oracle 9I • Other Tools – BIMA,DIMA