The following steps are involved in the conversion process as mentioned below in the diagram
· Data cleansing process will be completed in three phases.
· Phase 1: Manual cleansing in legacy system
· Phase 2 : Data correction, functional mapping and transformation during extraction
· Phase 3:Reviewing the extracted data and manual correction
· Data Extract sign off
· Data load in Oracle
· Functional unit test and data validation in Oracle applications
· Data owner sign off
A variety of factors need to be taken into account while making a selection of tool/approach for data conversion. The factors to be considered are:
· Volume of data
· Existence of Oracle open interface table for data
· Existence of Oracle APIs that support the data to be converted
· Complexity of the data fields and data relationships within Oracle
Conversion programs should be designed to use to cross reference through AOL features (e.g. Lookups) wherever necessary for transformation of data from legacy values to Oracle values. Any change in the mapping should not impact the conversion code.
No comments:
Post a Comment