I have a requirement like this.
We have a data warehouse and 12 downstream datamarts, which are all populated using datastage jobs.
Each datamart is in a separate project.
There are four columns to be searched , let them be A,B,C,D.
Is there any easy way to do this.
What i thought is export the project as dsx, search for those 4 columns
.Will it give me the job name where these columns are used along with the path.
Is this fine or wrong or is there any easy way to do this
By using usage analysis can we do this? I don;t think we can do this.
Impact analysis
Moderators: chulett, rschirm, roy
Impact analysis
Aim high
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
DataStage Manager Usage Analysis on saved table definitions can be unreliable as it depends on programmer discipline. If the developers only entered column information by loading the same table definition into all jobs that needed it then it will work. If they took a different route, such as entering columns manually, or using a table definition that was subsequently deleted, or using one in a different location, or saving a definition in one job and using it in another, then there will be no one table definition that provides comprehensive usage analysis.
As Kim recommends the best way is to look for the column names via one of the reporting options as per the reporting FAQ.
As Kim recommends the best way is to look for the column names via one of the reporting options as per the reporting FAQ.
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: