Build and Strategy for conversion of Legacy Application using ODI, and Staging Table.
Steps used to convert legacy application.
- Create the service using ODI services to interact with data files.
- Copy the data content from the Data File to a Standard Schema namely (STD) and import them to intermediate tables.
- Using PL/SQL process apply business logic to read data from STD Schema Tables to CNV Schema Tables and import them to application tables.
- Apply Reconciliation process using Informatica to Compare the data between STD Schema table to legacy application data/ business data.