On June 19 @ 7 PM the current FRAME ETL will run to load the Oracle 10g Data Warehouse 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 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.
On June 20th, the NYTD and NCANDS reports will be changed to point to the new Oracle 11g Data Warehouse in order to run comparisons between the 10g Data Warehouse and the 11g Data Warehouse. The comparisons will be completed by noon.
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