| Sample
Code
|
 |
 |
Case
Studies - Learn how to better use Warehouse Builder with these
case studies. |
|
Restore_runtime.txt
- This script shows step-by-step how to restore
an entire Oracle Warehouse Builder target environment from a database
dump. The restore operation may include user OWBRT_SYS, runtime repository
owner, runtime access user and target schema. A subset of these users
can also be restored from a database dump using this script. The script
has been tested with OWB9.0.4 and OWB9.2. |
|
Modify
Process Flow Activities - This script contains
routines for: setting the SMTP server and port details for all MAIL
activities within the flow, setting the FROM_ADDRESS and REPLY_TO_ADDRESS
for all mail activities, and setting the deployed locations for transformations.
|
|
Capturing
User Inputs - This file contains classes
for a generic modal dialog that can be used from OMBPlus for capturing
user input. It will support parameters that are text or passwords. |
|
Setting
up user access - This package specification
allows you to use the module status (Production, Quality Assurance
or Development) to limit user rights. In this sample only the design
repository owner has all access all the time. Read the header of the
code to understand how to install and de-install, and for more information
on functionality provided. |
|
How to deploy from files with Warehouse Builder 9.2 |
|
Warehouse
Builder Hands on Materials from Oracle World 2003 |
|
Slowly
Changing Dimensions with Oracle 9i Warehouse Builder (9.0.4) |
|
How
to use a CASE Statement as a Transformation |
|
Warehouse
Builder Sample Metadata - This sample is
underlying the business case described in the Oracle
Magazine article . |
|
How
to change the file name for the external table
- This sql script lets you change dynamically the file name for the
external table used in the mapping. For OWB 9.2 |
|
Restore_repos.txt
- This script shows step-by-step how to restore
an Oracle Warehouse Builder metadata respository from a database dump.
The script has been tested with OWB9.0.4 and OWB9.2. |
|
Run_my_owb_stuff.sql
- This script will create a database function
in the runtime repository schema that can be accessed in order to
run OWB generated mappings or procedures. The resulting function can
be used for direct database calls or database schedules. The function
can be used in addition or instead of the sqlplus_exec_template.sql
script Warehouse Builder ships in <owb home>\owb\rtp\sql. |
|
UpdMapConfig.tcl
- As of version 9.0.4 you should use locations
and connectors instead of schema name and database link configuration
properties in the mapping editor. This script will do a background
reset of all old configuration properties so that you directly start
using the locations and connectors. Instructions on how to run the
script are included as comments in the script. |
|
Tablespace
Setting - This script contains a number
of routines for setting the tablespace for all object types in an
Oracle Module which have tablespace configuration parameters. These
procedures can be used for quickly changing the values en-masse. The
procedure ts_wh should be passed a tablespace name and a value for
the hash partition tablespace list (an empty string can be passed
here). This procedure will set the TABLESPACE configuration parameter
for all objects types (includes indexes, partitions etc, if there
are any for table, dimension, cube, AQ, MV). |
Bookmark
