hi guys,

I have a question regarding the sqlldr in oracle. It is about the control file. I have a input .csv file, and I would like to load the csv column 'COUPON' to two of my database columns, let's say 'INTEREST_RATE' and 'COUPON'. is it possible to do that in sqlldr? How should the control file look like? Please take a look at what I have here.




my input file: 'data190.csv'
----------------------------------------------


DEAL_NUM, LOAN_NUM, COUPON
MyTest,100,8.7
MyTest2,201, 9.3


MY control file
---------------------


Code:
LOAD DATA
INFILE 'data190.csv'
REPLACE
INTO TABLE LOAN_TEMP
fields terminated by ','  TRAILING NULLCOLS
(
        DEAL_NUM CHAR NULLIF DEAL_NUM=BLANKS,
        LOAN_NUM INTEGER EXTERNAL  NULLIF LOAN_NUM=BLANKS,
        COUPON DECIMAL EXTERNAL  NULLIF LOAN_WAC=BLANKS,
        INTEREST_RATE DECIMAL EXTERNAL  NULLIF LOAN_WAC=BLANKS

)


In the data file, I have 3 columns but in the control file I have 4 columns, so I don't think the control file above will work. Anyone has an idea on how to handle this kind of problem?

Thanks.