Interfaces real time questions 1. when we r doing interface/conversion which things u will take care to improve the perfornmance ? except bulk collect 2. In conversion,u r loading the data using sql*loader, I dnt want to use sql*loader ,& i have millions of records,Is der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion ,that using sql*loader u r loading data into staging table, u r writing control file bt I dnt want to use sql*loader, when u r creating con prog that time can we pass all values from flat file using paramere, valuset ? how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after that client understood that 1 item having wrong name e.g instead of ABC he given DCE, so can we delete? hw ? (client permission is der) i have lot of wrong item name randomly spreaded, can we delete it ? hw? 5.after doing validation hw u will follow approach to error out records? if i want to send all the error out records to client daily,whats is the approach? 6. In outbound interface is der any way to load the data (large data-millions of records) except UTL_FILE package?