We are on DataStage 8.1 - we need to change a column, we want to list all jobs that use that column.
- The DataStage Designer search function returns all jobs that use that column but does not have any way to copy, report or export that job list.
- The Metadata Workbench can search for that column but returns column names and not job names.
We don't seem to have any way in version 8.1 to do a simple column impact analysis that can be put into a report and printed off.
How to report on all jobs that use a column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
How to report on all jobs that use a column
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Re: How to report on all jobs that use a column
Hi
Datastage doesn't have the feature . I was working BO dataintegrator need just put column name it will return all the jobs which uses that columns name . metadata management is excellent in BO dataintegrator
Thanks
Sanjay
Datastage doesn't have the feature . I was working BO dataintegrator need just put column name it will return all the jobs which uses that columns name . metadata management is excellent in BO dataintegrator
Thanks
Sanjay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: