Team Wipro overcame the following initial challenges

	Providing flexible data warehouse infrastructure to accommodate DSS specific requirements. Microstrategy tool's alignment towards snow flaked schemas Database views, materialized views to address complex Brio reports Non-complex joins for MS Access users
	Data mart implementation against highly dynamic source system changes
	Building a staging area to address requirements of downstream systems other than the data mart
	Understanding and modeling data relationships from complex systems such as SAP, I2 demand planning/supply chain planning, Siebel, etc...
	Accommodating for the different kinds of seasons as well as differing history requirements on product, season, etc.
	Huge volumes of data and a small load window to load
	Working around tool challenges
	Modeling an hybrid Product dimension accommodating for the SCD type I, II requirements
	Modeling data for the SAP centric view and providing flexibility for legacy system data view

In order to avoid long running maps, all the fact loads were split into small and simple mappings that loaded temporary tables concurrently, which were eventually used to load the facts. Oracle's processing power was harnessed by maximizing the use of the source qualifier queries and was used over Informatica's processing capabilities, which led to faster load times. Job control tables and good design of staging tables ensured good restart and reprocessing capabilities, which has always been tools' Achilles Heel. Temporary tables and efficient maps ensured that the true increment was captured without compromising on the load time, hence ensuring good data quality without hitting the performance. The following technologies were used

	Hardware: HP-UNIX N9000 running HP-Unix Ver 11
	Data Warehouse and Staging Database: Oracle 8.1.7.0.0
	Data ETL: Informatica Power Center 5.0
	Modeling Tool - Erwin 3.5, ModelMart 3

The solution has helped client to reduce Inventories without sacrificing on stock-outs, plan the product distribution, marketing efforts and promotions and track the sales team's performance.