ORACLE Warehouse builder usage note
---------------------------------------

* OWB is fairly user-friendly. This note is to supplement what is not stated in the
official OWB user mannual.


OWB 9.0.4
----------
* The runtime platform for Warehouse Builder 9.0.4 requires software outside the database. 
  This software, the runtime platform service, can be installed in a separate Oracle home. 
  The runtime install has to run on the machine that will contain the target database structures. 
  Each separate runtime repository in a database requires a unique copy of the software. 
  (There is no specific reason why you would create multiple separate runtime repositories.)

* The new users accounts to create
  (repository assistant)
  OWB repository owner : owbadmin/owbadmin
  
  (OWB runtime assistant)
  OWB runtime repository owner: owb_rt_repo/owb_rt_repo 
  OWB runtime access user : rt_user/rt_user
  versioning user(created automatically): OWBRT_SYS
  OWB target schema : owb_target/owb_target - where jobs will run

* API4006, API2414
  9.0.4 version has problem with creating ORACLE module as "data source", you get these
  errors when trying to create database links. Choose "data warehouse target" instead.

* API2401: db link does not point to a valid ORACLE data source.
  When trying to import porcedure for transformation.
  When trying to import into an ORACLE module which does not have any db link
       defined during module creation.

* SQL*NET
  OWB seems to be able to find the right TNSNAMES.ORA to use, if you have an existing ORACLE Home
  and install OWB to another home.

* About Flatfile module : 
    The name of the module must be different from any location name.
    The directory associated with the module is where you import files from.

* How do you delete a project?
  You can not delete a project while the project is open. Go to another porject and then right
  click on the project you want to delete.


* test case 1: simplest of case
  Schedule a job to pick up a file from a location and load it into a table in the target database.

  0. Create a DW account dw_target at target ORACLE db.
  1. Create project
  2. Create flat file location
  3. Create flat file module: leave deploymeny location unspecified.
  4. Create ORACLE location
  5. Create ORACLE target module: 
     Create new db link dw_target_phoenix;
     Specify phoenix as the deployment location.
     If this is a "data warehouse module", why do I still need to specify deployment location?
  6. Import flat file data source:
     Sample the data, change the column name from the default c1, c2,... -> should see green light.
  7. Create a table in the target DW module.
  8. Create a mapping to link flat file source to the DW target
  9. Create a process flow: leave deployment location unspecified.
 10. Create package for process flow
 11. Create process for the package.
 12. Choose mapping and select mapping from 8 into the work area.
     Problem: when validating flow