-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|