maruthi

• Jan 28th, 2007

 

uploading data from legacys system having four steps to process the data from legacyes system to apps those r flat file---tepmrary table ----interfaces---basetableswe will recieve flat file from our client then 1.create sql*loader to upload data from flate file to temparary table2.before that we have 2 create temparary table3.after that we have 2 run sql loader to up load data to flate file4.then we will get the data into t.table5.then write interface program to upload from t.table to interface before that we have to delete thatt.table data when we writing interface6.then run sysytem interfaces to upload data from inter face 2 base tablesexample:in gl module to upload data from interface to base tables we have 2 use journal import