Bigdata DWBI

The objective of this proof of concept project is to evaluate the feasibility of converting a traditional ETL architecture for data warehouse load into a hybrid approach with bigdata integration.   Refer the following post for architectural details.     http://www.bigdatadwbi.com/2015/08/dw-architecture-traditional-vs-bigdata.html Proof of Concept - Project Plan  The POC project has a timeline of 4 weeks. Following activities planned during this period

DW Flow Architecture - Traditional             Using ETL tools like Informatica and Reporting tools like OBIEE.   Source OLTP to Stage data load using ETL process. Load Dimensions using ETL process. Cache dimension keys. Load Facts using ETL process. Load Aggregates using ETL process. OBIEE connect to DW for reporting.