Location: Oracle Warehouse Builder

Discussion: Expert: Source-to-Target Impact AnalysisReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 4 posts
anthonychow
anthonychow
Expert: Source-to-Target Impact Analysis
Nov 21 2007, 10:36 AM EST | Post edited: Nov 21 2007, 10:36 AM EST
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?    
limbok
limbok
1. RE: Expert: Source-to-Target Impact Analysis
Mar 10 2008, 12:25 PM EDT | Post edited: Mar 10 2008, 12:25 PM EDT
I am interested in using your project. What version of OWB is it saved as? Do you find this valuable?    
anthonychow
anthonychow
2. RE: Expert: Source-to-Target Impact Analysis
Mar 10 2008, 1:21 PM EDT | Post edited: Mar 10 2008, 1:21 PM EDT
The OWB client runs on Microsoft Windows 2000 in version 10.2.0.2. The server is a Sun 64-bit Solaris 10 in version 10.2.0.3 Do you find this valuable?    

antonio.romero
3. RE: Expert: Source-to-Target Impact Analysis
Apr 2 2009, 5:37 PM EDT | Post edited: Apr 2 2009, 5:37 PM EDT
The expert has now been moved to the OWB blog:

http://blogs.oracle.com/warehousebuilder/2009/04/usercontributed_utility_source_to_target_impact_analysis_expert.html Do you find this valuable?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
SCD Type2 Accelerator for Table Operator Purge audit records in OWB at ease more books
Major Steps for installing OWB 10gR2 & workflow in Window environment Oracle Warehouse Builder Export all OWB projects with a batch job
Deploying tables in an OWB Expert OWB Export Projects Utility OWB Installation Considerations
Getting Started With Oracle OLAP Option Expert: Source-to-Target Impact Analysis