How To Load data In Staging Table

Interface is used to transfer data from Flat file to Temporary tables.
interface creation.........................
1)create csv file using the xls file
2)create ctl file
3) create New table in given instance or in database
4)then ccreate concurrent program with name as (sql loader program...as
concurrent program) to load
data from the csv to the database table


steps to remember remark..........

always give same name to all csv,ctl,table in apps,
concurreent program and all

move csv and ctl file in the bin of custom_top

always do the validation while loading data.................

always refer the ctl
always use the append mode to append the data in the table it does not
append the data  but it is replacing the data to the table................
modes
1)insert
if the table alredy contains the data....................
 then use the following options to load the data..................
2)append   APPEND REPLACE TRUNCATE
3)update
4)modify
give path of csv in ctl
and table name of oracle apps and the
all fields of table in oracle apps


and the ctll file is............


LOAD DATA
INFILE '/u03/DEV/devappl/custom_top/11.5.10/bin/Invoice_headers90.csv'
APPEND INTO TABLE INVOICE_HEADERS_STG90
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
  INVOICE_AMOUNT,
  INVOICE_CURRENCY_CODE,
  PAYMENT_CURRENCY_CODE,
  INVOICE_DATE DATE 'MM-DD-YYYY HH24:MI:SS',
  INVOICE_NUM,
  INVOICE_TYPE_LOOKUP_CODE,
  PAYMENT_METHOD,
  TERMS_NAME,
  TERMS_DATE DATE 'MM-DD-YYYY HH24:MI:SS',
  VENDOR_NAME,
  VENDOR_SITE_CODE,
  INVOICE_HEADERS_STG90_ID "INVOICE_HEADERS_STG90_S.NEXTVAL"
 )


for ctl file......and interface information....

http://www.aboutoracleapps.com/2007/08/sqlloader-qns-what-is-sqlloader-ans.html
http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_use_the_SQL.2ALoader_utility.3F

imp file for ctl studyyy...............
---http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch05.htm