| Dynamic Flat File Name(Source) [message #391669] |
Thu, 12 March 2009 22:58  |
kamonsak.l
Messages: 1
Registered: March 2009 |
Junior Member |
|
|
Hi all
Can any one please help me , how to develop source with dynamic flat files name such as "YearMonthDate.txt"?
Thank You
Kamonsak(Thailand)
|
|
|
| Re: Dynamic Flat File Name(Source) [message #391894 is a reply to message #391669] |
Sat, 14 March 2009 05:32  |
ajitpal.s
Messages: 168
Registered: November 2006 |
Senior Member |
|
|
Im not sure if its possible using owb. I found a link on oracle but its not current
http://forums.oracle.com/forums/thread.jspa?threadID=210347
Theres a workaround anyway.
What we can do is define two files
1) Data file (fixed file name)
2) Control file (contains info about the data file, ie: record count of data file, business date of data file, process date of this data file, and other neccessary information.
Then you can use the control file to identify when the data file was processed, business date of the data file content, etc)
Hope it helps.
|
|
|
| Re: Dynamic Flat File Name(Source) [message #392106 is a reply to message #391894] |
Mon, 16 March 2009 07:19 |
ajitpal.s
Messages: 168
Registered: November 2006 |
Senior Member |
|
|
I found a document to handle variable file name processing via owb.
Look for section "How do i handle Flat File With Variable Names" in the file attached
I would suggest this document is attached to faq section for owb, i noticed most of the questions by users can be found in the document
[EDITED by LF]
You have attached a document which is protected by copyright. OraFAQ does not host such documents, so it has been removed. Please, do not do that any more.
You may, however, post a link so that other people might read it.
[Updated on: Mon, 16 March 2009 16:43] by Moderator
|
|
|
] 
Members
Search
Help
Register
Login
Home
