OraFAQ Forum: Client Tools » OWB File loading through External tables

Home » Other » Client Tools » OWB File loading through External tables (OWB 10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OWB File loading through External tables [message #499641]

Tue, 15 March 2011 10:49

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

Report message to a moderator

Re: OWB File loading through External tables [message #499643 is a reply to message #499641]

Tue, 15 March 2011 11:00

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: OWB File loading through External tables [message #499687 is a reply to message #499643]

Tue, 15 March 2011 13:16

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

Report message to a moderator

Re: OWB File loading through External tables [message #499688 is a reply to message #499687]

Tue, 15 March 2011 13:20

BlackSwan
Messages: 26766
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 10:14:04 CDT 2023