Page 1 of 1
Datastage jobs Using Oracle Table
Posted: Fri Feb 11, 2011 9:40 am
by pavan_test
Can anyone please suggest me how do I find out the list of all datastage jobs using a particular oracle table say "employee".
Thanks
Mark
Posted: Fri Feb 11, 2011 9:57 am
by kumar_s
If you had saved the metadata in the repository, you can do the Usage Analysis based on the Table Defenition.
Datastage jobs Using Oracle Table
Posted: Fri Feb 11, 2011 10:05 am
by pavan_test
actually we havne't saved the meta data for this particular table. There are round 500 datastage jobs in the project. So trying to find out if there is any way I can use sql to query and find out list of all datastage jobs using a particular oracle table.
Posted: Fri Feb 11, 2011 10:44 am
by chulett
Not sure how much of this will still work in the 8.x world but do an exact search here for "OLETYPE" and go from there.
Posted: Fri Feb 11, 2011 1:45 pm
by ray.wurlod
Learn from the experience. Always manage your metadata rigorously.