Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'file'
Batch unload and remote agents
This post illustrates natively unloading from other database systems such as Microsoft SQL Server using the Oracle 11g database scheduler's remote agent. This is all driven from the database via PLSQL api calls. The package relies on installing the lightweight...
Event Based Execution - File Arrival Example
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...
Binary Files in OWB - Simple Example
So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the vast majority of...
Dynamically generating target file names
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...
Process Flow - Execute a map for all files in a directory - Part 2
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...
Process Flow - Execute a map for all files in a directory
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...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'file'.
