Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating dynamic file names

659557Oct 21 2008 — edited Oct 23 2008

Ok now I am getting somewhere with OWB. Well all thanks to you guys for helping me out with my questions. Anyway now I am facing an issue I want to create the output files with today's file name. I mean if i am running the mapping on the 20th of October the file name should be xyz10202008.txt. If I am running the mapping on 25th of October the file name should be xyz10252008.txt. In the configure option where we specify the actual file name can we give an expression. In SSIS there is an option like that to customize a file name for the date. How do we simulate the same in OWB? Would appreciate all the help I can get.

thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2008

Added on Oct 21 2008

#data-warehousing, #warehouse-builder

3 comments

519 views