Search a Field in Datastage Repository

talk2shaanc · Post by **talk2shaanc** » Fri Jan 25, 2008 6:36 am

I would like to find all the jobs having a particular field.
Would like to know which internal Datastage Hash file should I search to get the same?

Note: Cannot use Datastage manager for Usage analysis as Metadata management(Table Definitions) are not maintained properly.

WoMaWil · Post by **WoMaWil** » Fri Jan 25, 2008 7:01 am

But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

talk2shaanc · Post by **talk2shaanc** » Fri Jan 25, 2008 7:10 am

WoMaWil wrote:But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

Metadata/table definition is

NOT

maintained properly. So reporting tool won't help.

chulett · Post by **chulett** » Fri Jan 25, 2008 8:04 am

Reporting Tool not equal Usage Analysis. Two different things.

You could also find posts from Chuck Smith and get his free utility that would help in this effort. The URL is www.anotheritco.com from what I recall.

kduke · Post by **kduke** » Fri Jan 25, 2008 2:54 pm

viewtopic.php?t=99349&highlight=Search1

kduke · Post by **kduke** » Fri Jan 25, 2008 2:55 pm

viewtopic.php?t=99349&highlight=Search1

ray.wurlod · Post by **ray.wurlod** » Sat Jan 26, 2008 12:21 am

Select the table definition in which the field occurs and perform a usage analysis on it. When a usage analysis is performed on a table definition it reports the columns from that table definition that are actually used in the job. Having performed the usage analysis, go to its File menu and choose View HTML.