Hi friends,
can some one help me with sql * loader problem?
I have a flat file(data for 10 fields ) with data to be loaded into table A(10 fields). Before loading into table A, the 7th field's value from the datafile need to be mapped with Table B and corresponding value from that tableB needs to be replaced in flatfile and then loaded into tableA. So, after the loading, tableA will contain values 1 to 6 and 8 to 10 from the original flatfile and 7th value from tableB.
Can someone help me with the stored procedure required to make it work?
I am running 8.1.6 on tru64 5.0 compaq ES-40
Thanks
manjunath