Hi
I am using using Datastage 7.5 version. I am having a quick query like , is it possible to find out for a given column in the metadata , what are all the jobs that column is referenced like that?
I would appreciate your help.
Find the Job Name
Moderators: chulett, rschirm, roy
Find the Job Name
Regards
Lotus26
Lotus26
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Select the table definition in Manager and perform a Usage Analysis. This will show you which jobs use that table definition. Scroll to the right of the report and it will show you which columns are used.
Note that this assumes you have been rigorous in maintaining the connectivity between jobs and table definitions in the Repository.
Column-specific usage analysis does not become available until version 8.1.
Note that this assumes you have been rigorous in maintaining the connectivity between jobs and table definitions in the Repository.
Column-specific usage analysis does not become available until version 8.1.
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.