At 10 PM Friday, the current FRAME ETL will run to load the Oracle 10g Data Warehouse(DW) with DB2 as the data source and at the same time the new FRAME ETL will run to load the new Oracle 11g Data Warehouse(DW) with the CDC as the data source. The current ETL will be done in 5-6 hours and the new ETL will be complete in 30 minutes.
Cognos reports will be run against the old DW and the new DW and compared for differences.
The NYTD and NCANDS reports will be changed to point to the new Oracle 11g DW in order to run comparisons between the 10g Data Warehouse and the 11g Data Warehouse.
The Cognos DW reports and NCANDS and NYTD reports will continue to point to the new 11g Data Warehouse if the comparisons are good.
FRAME Users running Reports from the Data Warehouse