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
How Can I find "Used by DsJOb" or "USed by Or
Moderators: chulett, rschirm, roy
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
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
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
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.
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.
Chuck Smith
www.anotheritco.com
www.anotheritco.com