DSXchange

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.

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.