nd.gov - The Official Portal for North Dakota State Government
North Dakota: Legendary. Follow the trail of legends

DHS FRAME Production Data Warehouse Upgrade and ETL change

June 21, 2013 - 10:00pm - June 23, 2013 - 11:49am

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.

Who's Affected

FRAME Users running Reports from the Data Warehouse

 

What Our Customers Are Saying

Thanks for the fast response and resolution.

Office of Management and Budget
September 5, 2014
 
 

Copyright © 2014 North Dakota Information Technology Department - ITD
Use Adobe Reader to view, print and collaborate on PDF files.