Usage analysis of a table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Roopanwita
Participant
Posts: 125
Joined: Mon Sep 11, 2006 4:22 am
Location: India

Usage analysis of a table

Post by Roopanwita »

Is there any way to see Usage Analysis of a table in datastage,if metadata of that particular table hasn't been imported(present ) in DS manager,but the particular table is used in DS jobs.
Thanks in advance
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Not directly. If you hard-coded the table name then it might be possible to search through the exported .dsx file and look for occurrences in different jobs.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No.

There are internal linkages maintained between the table definitions branch of the Repository and job designs into which those definitions have been loaded or from which table definitions have been saved.

If you right click on the Columns grid in a passive stage in a job design you will find that you can display these linkages. There is also a check box that allows them to be edited (at your own risk) in more recent versions of DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply