Hi,
I am interested on a tool which allows to help me answer the following questions:
* which job is reading which table / view
* which job is manipulating a certain data element
* which job is updating a table /view
Is there any tool on the market to perform such cross reference analysis?
Many thanks
GuidoMarcel
Datastage cross references
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Usage Analysis in Manager.
All these tools require that your metadata management has been exemplary, that you have not invalidated the linkage between the table definitions in the Repository and those in the jobs.
You can determine (version 7.5 and later) whether these are intact by opening a Columns grid in a stage in a job. Right click in the grid itself and choose Properties. Enable all the hidden fields, particularly the final one (source table definition, or some such name).
All these tools require that your metadata management has been exemplary, that you have not invalidated the linkage between the table definitions in the Repository and those in the jobs.
You can determine (version 7.5 and later) whether these are intact by opening a Columns grid in a stage in a job. Right click in the grid itself and choose Properties. Enable all the hidden fields, particularly the final one (source table definition, or some such name).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Fri Feb 20, 2004 4:25 am
Each job will create its own BASIC code, but still you have set of hashed files, where it acts as a common repository for the metadata of datastage. Where the guys who answere above in your post were very much expert in extracting the required data from it. Generally it is not suggested.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'