sql loader control file
Posted on 2010-11-18
I am loading data from a csv file, and I am getting customer_id value from csv file, I want to insert the same customer_id into 3columns. 2columns are in 1 table and another column is in another column. The same thing in the form of query is
Insert into to2_user (customer_id, login, password) select customer_id,customer_id,customer_id from dps_user.
The control file is not allowing me to reference customer_id for multiple places because it has to read the data from the beginning of the row.
How to mention this in control file. Please help.