Business Requirements Below are the different phases sorted by how they will be performed. The detail activities within each phase are listed in the "Execution Approach" section of this document. Phase 1 – Business Analysis and Design Phase 2 – Installing Informatica/Business Objects Phase 3 – ETL (Extract, Transform, Load) Development and Testing Phase 4 – Reporting Universe Development and Report Development Phase 5: Implementation Support and user trainingStep 6: Implementation and Production Support Project Deliverables• Loading historical data and mapping data from current systems to the new data warehouse. A standard mapping scheme will be created that will be the same for all business units. Once approved, each department is required to provide all data from all business units in this standard schema if connectivity to the source data cannot be achieved using Informatica.• Historical data mapping will only be performed for the amount of data available and may not meet all data requirements in some cases. • Report specification document and code for reports • Design document and code for web-based portal • Document showing entities/relationships in data marts. • Document showing the Business Objects universe. • Business Objects Universe. • Technical design document for ETL and Reporting.EXECUTIONAL APPROACHStep 1 – Business Analysis and DesignCollaborate with users across business units to clearly identify business requirements and design the solution.• Analysis and design of historical data load from various sources to the internal to all business units.• Web design Advertising portal based to connect different reporting areas to the data warehouse; this portal will also have the ability to connect to external databases...... middle of paper ......and with advanced parallel processing of all data warehousing operationshttp://www.oracle.com/services/index .htmlBusiness Objects BusinessObjects : Self-service analytics for users.• BI platform: Manage BI tools, reports and applications.• Data integration: Access, transform and integrate data.http://www.businessobjects.com/products/businessobjectsxi/default .asp?intcmp=hp_products2