-
Data Warehouse 9.0 testing prep
-
Period: to
Prep for testing
Get acocunts for our 9.0 instances
HACHITST
HACHIUPG
setup Firewall rules
setup Dev databases -
Period: to
Test Staging pull process
-
Clob issue found
In our 9.0 databases columns that were long are now clobs. time to pull tables with clobs increased exponentially.
example: ps_communications use to take 3 minutes now takes 8 hours -
Period: to
Investigate clob issues in table pull
Clob issue writeupWe did very extensive testing on this -
Found a workaround for Clobs
After lots of back and forth with George Mansoor at CMS, Chico State found a workaround for the clob issue. The workaround is not scalabale but does work currently. Still awaiting reply from George Mansoor for a solution our a document stating why no solution -
Begin Analysis of source and staging tables
-
Period: to
Staging table comparison
Analyze the differences in staging tables making note of the following:
Missing fields
New fields
Data type changes
Data length changes
Precision changes
scale changes -
Begin RDS Analysis
-
Period: to
Catalog issues building Data Warehouse from 9.0 tables
Continuously rerun Data Warehouse builds and document issues that we find -
Period: to
Iteratively resolve issues
-
Developer testing begin
-
Period: to
Developer Testing
This testing will be iterative and cyclical.
Test, fix, test, fix -
Ready for production