Expert: Source-to-Target Impact AnalysisThis is a featured page

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


No user avatar
antonio.romero
Latest page update: made by antonio.romero , Mar 18 2008, 2:48 PM EDT (about this update About This Update antonio.romero Transcribed from Anthony's original forum post - antonio.romero

127 words added

view changes

- complete history)
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.