Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Location: Oracle Warehouse Builder
Threads
???keywordTags???
???noTags???
Posting...
Note: You can enter up to [REMCHARS] additional characters.
Did you know you can edit the content of this page by clicking EasyEdit?
Did you know you can edit the content of this page by clicking EasyEdit?
| 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
3
out of
5 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
Expert
Impact Analysis
Oracle Warehouse Builder
OWB
Show Last Reply
|
|||||
| 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
7
out of
12 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
Installation consideration
OWB
Show Last Reply
|
||||||
| 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 find this valuable?
Do you?
Keyword tags:
ksh
OMB+
Oracle Warehouse Builder
OWB export
tcl
Show Last Reply
|
||||||
