Oracle Warehouse Builder (OWB) Weblog

Event Based Execution - File Arrival Example

By david.allan on September 8, 2008 2:38 PM

If you want to do truly event based execution based on arrival of a file there is a convenient package supplied with the Oracle database scheduler component that can be used, the package can be downloaded from OTN here. For...

Comments (1) | TrackBacks (0)

Dynamically generating target file names

By david.allan on July 9, 2007 5:11 PM

A little known fact is how to dynamically create a file name for a map that has a file as a target (for example). The configuration property 'Target Data File Name' allows a data file name to be entered, it...

| TrackBacks (0)

Process Flow - Execute a map for all files in a directory - Part 2

By david.allan on July 6, 2007 1:57 PM

This note is a description of a useful expert (download at end) for generating process flow components for loading all files from a directory based on the design in the earlier post described here. The expert prompts for minimal information...

| TrackBacks (0)

Process Flow - Execute a map for all files in a directory

By david.allan on July 5, 2007 3:53 PM

How to call a map for every file in a directory? Flat file maps have the data file name as a parameter. The map can be called from a flow and the data file name set, the map will be...

Comments (4) | TrackBacks (0)

File Listing/XMLType from a stored procedure

By david.allan on May 2, 2007 4:59 PM

Ever wondered how to get a list of file names in a directory from within the Oracle database? See post for more details on OWB. This is something I've done in 2 cases, one which happens to use the XML/SQL...

| TrackBacks (0)