Already a member?
Sign in
Welcome! Wikis are websites that everyone can build together. It's easy!
Oracle Warehouse Builder
Welcome!
Wiki Resources
Please add new Wiki pages to the list of links below.
- Utilities and Experts - Post interesting ones here!
Installation Tips and Tricks
- Oracle Workflow: Tips on installing workflow as used with OWB.
Usage Survey
Do you want to give your 5cents on what is important in OWB or what you want next? Fill out the survey now and let your voice be heard!
Go to the blog (here) and fill out the survey. Make sure you send it using the email send option.
Other OWB Web Resources
- OTN OWB Product Page
- OTN OWB Documentation Index
- OWB Forum
- Metalink: Releases and Patches until OWB 11g
Recent Activity on other OWB Web Sites
Latest page update: made by jdijcks
, Apr 14 2008, 5:05 PM EDT
(about this update
About This Update
Added the link to the blog/survey
- jdijcks
48 words added
10 words deleted
view changes
- complete history)
Added the link to the blog/survey
- jdijcks
48 words added
10 words deleted
view changes
- complete history)
Keyword tags:
audit
data
data governance
data quality
ELT
ETL
governance
integrator
knowledge module
Oracle Warehouse Builder
OWB
More Info: links to this page
| Started By | Thread Subject | Replies | Last Post | |
|---|---|---|---|---|
| anthonychow | Expert: Source-to-Target Impact Analysis | 2 | Mar 10 2008, 1:21 PM EDT by anthonychow | |
 |
Thread started: Nov 21 2007, 10:36 AM EST
Watch
The goal for this Expert is to locate all target tables for any given source table and output the results to a CSV. Through OMB+, I used the technique of parsing the result strings from OMBIMPACT DEPENDENCYTYPE calls.
Some assumptions used during development, which you can certainly modify: · "Project" is equivalent to projects shown as top nodes in the Project Explorer · "Study" is equivalent to Oracle databases under each project · Select to analyze multiple source tables by using the Ctrl key · Target tables have "_FINAL" as the suffix in the name Known limitations: · Patience is certainly virtuous; great results take time to produce · OMBIMPACT DEPENDENCYTYPE is unable to detect impacts against columns embedded into expressions; and the pivot and unpivot operators
2
out of
4 found this valuable.
Do you?
Keyword tags:
Expert
Impact Analysis
Oracle Warehouse Builder
OWB
|
|||
| htu | OWB Installation Considerations | 4 | Dec 3 2007, 4:10 PM EST by htu | |
|
Thread started: Nov 21 2007, 11:25 AM EST
Watch
If you plan to install Oracle Warehouse Builder, Here are the things that you need to consider:
1. Choose your implementation strategy: Basic Implementation, Traditional Client/ Server Implementation or Split Repositories Implementation. 2. Choose what versions to be installed on a server and clients. Here are the products and their versions that we have installed: a. Oracle Database on the server - Oracle DB 10gR2 (10.2.0.1) - Oracle DB patch set (10.2.0.3) b.Oracle Warehouse Builder on the server and clients OWB 10.2.0.1 - OWB patch set 5696353 (10.2.0.2) - OWB one-off patch: 6270894 + Fix Stack over flow problem +Must apply on client side (readme file is not clear) and can also apply on server + Will not get fixed until OWB 10.2.0.4 (OWB 11g = 10.2.0.3) c. Repository Owner - Only one OWB repository owner in the database is recommended 3. Layout your project structure 4. Plan storage (tablespace) for projects
6
out of
11 found this valuable.
Do you?
Keyword tags:
Installation consideration
OWB
|
||||
| htu | Export all OWB projects with a batch job | 6 | Nov 21 2007, 12:09 PM EST by htu | |
|
Thread started: Nov 21 2007, 11:41 AM EST
Watch
I have developed a ksh script to run an OMB+ script to export all the projects in a OWB repository. The scripts will be posted in the end.
Know limitations: - it requires single user mode to connect to the repository - it stops the export if users are still in a project
6
out of
8 found this valuable.
Do you?
Keyword tags:
ksh
OMB+
Oracle Warehouse Builder
OWB export
tcl
|
||||
|
sp_get_pm.sql (Unknown File - 5k)
posted by htu Dec 3 2007, 4:04 PM EST
Stored procedure for tracing back dangling objects to t heir corresponding projects and modules.
|
|
|
|
owb_exp_prjs.tcl (Unknown File - 13k)
posted by htu Nov 21 2007, 12:08 PM EST
This OMB+ script was from OWB beta and modified so that the exports will be saved in a separate folder for each run.
|
|
|
|
run_ombplus (Unknown File - 6k)
posted by htu Nov 21 2007, 12:03 PM EST
OK, here it is the whole script. Sorry for the code chunks.
|
|
|
OWB Impact Analysis Expert Oracle Wiki.zip (Compressed Archive - 208k)
posted by anthonychow Nov 21 2007, 10:45 AM EST
Expert: Source-to-Target Impact Analysis
|