How Can I find "Used by DsJOb" or "USed by Or

rajpatel · Post by **rajpatel** » Mon Aug 22, 2005 9:04 am

Hi,

How Can I -

1) I want to know HOw Can I find all the jobs which are using Oracel Table eg. "Emp table"
Meaning If i want to know what are the different job which used my table

2) In reverse, I want to know How Can I find all the table used by DataStage job

Please reply me back
--Raj

elavenil · Post by **elavenil** » Mon Aug 22, 2005 9:45 am

There are few ways to find out how many jobs are using the particular table and the ways are.

1. Usage analysis from DS manager. I think this way would give you the right results when you maintain the metadata properly in the project.

2. SQLs queries against Repository tables. Pls search the forum as this topic covered few times.

3. Search the table string in DSX file.

HTWH.

Regards
Saravanan

rajpatel · Post by **rajpatel** » Mon Aug 22, 2005 10:13 am

thanks!!! elavenil , I got it

elavenil · Post by **elavenil** » Mon Aug 22, 2005 10:20 am

You are welcome.

chucksmith · Post by **chucksmith** » Mon Aug 22, 2005 12:17 pm

I have never tried my tools on parallel jobs, but I guess that the format of a dsx file is the same, regardless of DataStage edition. If stages have the same descriptions, it should work.

I know Craig was about to suggest that you try my List all files and tables used by jobs in a dsx file tool.

You can find it on the DataStage Tools page of www.anotheritco.com.