User-Contributed Utility: Source to Target Impact Analysis Expert

Submitted by Anthony Chow of Octagon Research, this expert locates 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

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today