shaik ghouse

• Dec 28th, 2006

 

Generally to start with the role involves creation of staging tables by copying the same structure of interface tables so that it could be easy , these staging tables are to be loaded with leagacy data and then when u find the data in staging tables thru the SQL loader programs,

then we will run the package created to transfer the data from staging tables to interface tables with necesary validations made on the requied columns,

then when we find the data in interface tables then run the standard interface program 'Customer open interface Program' so that the data gets transferred from interface tables to oracle base tables.

may this help u,

Shaik