Oracle Warehouse Builder (OWB) Weblog

Expert: Useful scripts from simple primitives

By David Allan on January 16, 2009 5:05 PM

Here is a useful OMB scripting example to illustrate the basic mechanics of the OMB scripting grammar to create an expert. The expert has a couple of steps to get information from the user to load an object (file, table...

| TrackBacks (0)

Binary Files in OWB - Simple Example

By David Allan on January 25, 2008 11:39 AM

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...

| 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)