Home » SQL & PL/SQL » Client Tools » OWB File loading through External tables (OWB 10gR2)
icon4.gif  OWB File loading through External tables [message #499641] Tue, 15 March 2011 10:49 Go to next message
mishswati06
Messages: 4
Registered: August 2010
Location: Leeds
Junior Member
Hi ,

Is it possible to trim the file name while loading into OWB through external tables?

Like suppose I am trying to read a file which has a timestamp value appended in its name. In that case loading into external file would give an error.

Any way to achieve this. Please suggest.

Regards,
Swati
Re: OWB File loading through External tables [message #499643 is a reply to message #499641] Tue, 15 March 2011 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

post OS directory listing where file resides
Re: OWB File loading through External tables [message #499687 is a reply to message #499643] Tue, 15 March 2011 13:16 Go to previous messageGo to next message
mishswati06
Messages: 4
Registered: August 2010
Location: Leeds
Junior Member
Hi,

Sorry if I have not followed the guidelines.
Just to give some more details.
I am using OWB 10gR2. The source system for a mapping is a flat file(fixed length) in an ftl location.
The flat file is named such that there is a timestamp value appended to it. So this keeps changing with every load(its a monthly load).
Is it possible to achieve a way to trim the file name and just keep the constant part (via OWB).
I know a UNIX script can achieve this. what I want to know is , is this possible to achieve through OWB.
I hope my question is clear.
regards,
Swati
Re: OWB File loading through External tables [message #499688 is a reply to message #499687] Tue, 15 March 2011 13:20 Go to previous message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
one alternative is to use an OS soft link
ln -s <real_file> <constant_name>
The soft link is changed at OS level prior to every load then the DB side procedure remains unchanged.

[Updated on: Tue, 15 March 2011 13:21]

Report message to a moderator

Previous Topic: oracle 6i application
Next Topic: iSQL*Plus stopped working unexpectedly (2 Merged)
Goto Forum:
  


Current Time: Wed Jan 17 23:14:37 CST 2018

Total time taken to generate the page: 0.02007 seconds