1. Download all the tables from legacy systems
2. Sit with Business to decide which fields map to Oracle Directly and remove unwanted columns/tables. Note down the fields which can't map to Oracle directly. Most of them go as Descriptive Flex fields.
3. Make sure you have clean up process script ready before you do conversion, depending on the logic of the business
4. Load the data in the intermediate staging tables
5. Run the clean up process using the script
6. Generate report to functional review
7. Run the validation process
8. Use CRP 1 CRP 2 to minimize process. Try to get zero validation errors
9. You can use the 2 programs for validation a. API b. Interface table
10. Interface table program will have more control. We can use batch method in Interface which we cannot use in API
2. Sit with Business to decide which fields map to Oracle Directly and remove unwanted columns/tables. Note down the fields which can't map to Oracle directly. Most of them go as Descriptive Flex fields.
3. Make sure you have clean up process script ready before you do conversion, depending on the logic of the business
4. Load the data in the intermediate staging tables
5. Run the clean up process using the script
6. Generate report to functional review
7. Run the validation process
8. Use CRP 1 CRP 2 to minimize process. Try to get zero validation errors
9. You can use the 2 programs for validation a. API b. Interface table
10. Interface table program will have more control. We can use batch method in Interface which we cannot use in API
No comments:
Post a Comment