Page 1 of 1

MetadataworkBench tool Clarification

Posted: Wed Jun 18, 2014 3:31 am
by vamsi.4a6
I want to know whether following things are possible using MetadataworkBench tool.In our project we are using oracle Database,Datastage and Business Objects reporting tool.


1)I want to know list of Datastage Jobs using particular table or column in oracle database?
2)Which reports will be effected if I deleted a particular table from database?
3)How data is flowing in a project(Database-->Jobs->reports)?
4)List of stages in Job where we hard coded a particular column?

As per my understanding all the above things are possible but just want to cross check since
I do not have practical knowledge about this tool

Posted: Wed Jun 18, 2014 5:19 am
by eostic
Yes. You have to first learn about data lineage and the query tool, and how to browse and search for various objects, but yes, you can obtain those answers using the Metadata Workbench.

Ernie