Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Location: Oracle Warehouse Builder
Discussion: Expert: Source-to-Target Impact Analysis
Keyword tags:
Expert
Impact Analysis
Oracle Warehouse Builder
OWB
Watch
 anthonychow |
Expert: Source-to-Target Impact Analysis
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 |
RE: Expert: Source-to-Target Impact Analysis
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 |
RE: Expert: Source-to-Target Impact Analysis
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? |
