| || |
Data Migration test Strategy
I am doing Data Migration Testing.
Source is IBM Main Frames & other small dbs and Target is Oracle 9i.(No access to sources for testers)
There are huge number of Business Rules, Number of Translations and Data Conversion Rules.
Business is giving only an extract file from the sources which is loaded into Stagging tables before it goes into target.
1. I want to validate the extract before its loaded into target, applying business rules and check whether the data in Extract is correct
2. Want to Apply the Business rules, translations, conversions on target tables assuming that the data is correct in extract.
In phase 1 of our project, we never validated the extract and assumed it as accurate which caused problems in some areas of the functionality in Live . Hence risk involved in not validating the extract.
In Phase 2, I dont want to take that risk and the volume of data being migrated is relatively huge.
Also, I will be testing the refresh every month.
Please suggest how do I go about this testing with a resource estimate of 5 and duration of 5 months.
Re: Data Migration test Strategy
Something that may have be of use as one of the pieces/parts you must grapple with: