By antonio romero on April 2, 2009 1:31 PM
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
By antonio romero on April 3, 2009 9:16 AM
Oracle Warehouse Builder user Hanming Tu contrinbuted a Korn Shell script and OMB*Plus script to export all the projects in a OWB repository to MDL. (It should be possible to write a Win32-specific wrapper for use with the OMB*Plus script as well, if you don’t have a korn shell implementation on your Windows box.)
Known limitations:
- it requires single user mode to connect to the repository
- it stops the export if users are still in a project
You can download the script here
By antonio romero on April 14, 2009 4:58 PM
The Oracle Data Integration Linkedin Group (originally just an OWB group, now open to all users of Data Integration technologies with the Oracle database) is closing in on 500 members now.
Come join us at LinkedIn.
Group members include product management, development and marketing from the OWB and ODI teams, as well as users of each product, and recruiters and hiring managers looking for candidates with OWB skills. People post job leads, questions, and questions and discussions about the future of data integration at Oracle.
Will you be the one to put us over the top? (I sure hope someone is...)
By antonio romero on April 17, 2009 10:36 AM
Wow, you folks move fast. In three days we’ve added over 30 LinkedIn members, which has to be a good thing. Obviously somebody’s reading the blog… :)
More real content soon, I promise—we’re just in a busy time right now, working on OWB 11.2 and a few other surprises. Meanwhile, we’re also thinking ahead to OpenWorld planning… Let us know what you want to see there.
