- Data Mapping
During
the data mapping process, list of all the data sets and data elements that will
need to be moved into the Oracle tables as part of conversion are identified.
Data mapping tables are prepared as part of this activity that show what are
the data elements that are needed by the target system to meet the business
requirements and from where they will be extracted in the old system.
- Download Programs
After
the conversion data mapping is complete, download programs are developed that
are used to extract the identified conversion data elements from the current
systems in the form of an ASCII flat file. The structure of the flat file must
match the structure of the Oracle standard interface tables. These flat files
generated may be in text form or a comma or space delimited, variable or fixed
format data file.
- Upload Program
Once
the data has been extracted to a flat file, it is then moved to the target file
system and the data from the file is loaded into user defined staging tables in
the target database using SQL Loader or UTL_FILE utilities. Then programs are
written and run which validate the data in the staging tables and insert the
same into the Oracle provided standard Interface tables.
- Interface Program
Once
the interface tables are populated, the respective interface program (each data
element interface has a specific interface program to run) is submitted. The
interface programs validate the data, derive and assign the default values and
ultimately populate the production base tables.
No comments:
Post a Comment