sqlldr - look up on table to find column value
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?
EmpId EmpName Salary Date_paid
1 A 10 4/15/2009
2 B 20 4/18/2009
lookup Table dates
Target table Emp
EmpId EmpName Salary Date_paid_key
1 A 10 1001
2 B 20 1004
Last edited by nidi_03; 05-18-2009 at 03:10 PM.
No other suggestion, this is a two steps process: a) sqlload what you have, b) update as needed.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
May be able to consider External Tables.
Click Here to Expand Forum to Full Width