sqlldr - look up on table to find column value

[nidi_03]

Hi,

I am loading table Emp using sqlldr. I need to populate the column Date_paid_key of table Emp by lookin up on another table dates. Sample data is as given below. How can I do it using sqlldr? I can load my csv in a temp table and then proceed. Any other suggestions?

Src.csv
EmpId EmpName Salary Date_paid
1 A 10 4/15/2009
2 B 20 4/18/2009

lookup Table dates
Date Date_key
4/15/2009 1001
4/16/2009 1002
4/17/2009 1003
4/18/2009 1004

Target table Emp
EmpId EmpName Salary Date_paid_key
1 A 10 1001
2 B 20 1004

[PAVB]

No other suggestion, this is a two steps process: a) sqlload what you have, b) update as needed.

[ebrian]

May be able to consider External Tables.