Home » Developer & Programmer » Warehouse Builder » SQL LOADER - filenames
SQL LOADER - filenames [message #211273] Wed, 27 December 2006 13:45
Akshar
Messages: 116
Registered: May 2006
Senior Member

Hello Everyone,

Could someone please let me know how to store
or load filenames into table from where SQL LOADER
reading?

in other words I have a situation where the data filenames will change everytime, and SQL loader(by control file) will transfer data from that file. Now my requirement needs to put filenames also into the same table saying that this data has been loaded from this filename. Of course i have to create an additional column to hold filenames.

Is there any way to do this in SQL LOADER ?

Your insight is appreciated.

[Updated on: Wed, 27 December 2006 14:48]

Report message to a moderator

Previous Topic: extract data from flat file into target table
Next Topic: flat file as a target table and external table
Goto Forum:
  


Current Time: Thu Oct 23 14:00:39 CDT 2014

Total time taken to generate the page: 0.31468 seconds