Impact analysis

[nkln@you]

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.

[kduke]

You could use MetaStage or Reporting Assistant. In the later look in DSColumns for ColumnName. Do a search it is a little tricky to get around the doc_tool.mdb default menu.

It is even more complicated to go against DS_JOBOBJECTS.

[vmcburney]

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.

[ray.wurlod]

The best way is to have developer discipline. Enforced if necessary.