MetadataworkBench tool Clarification

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

MetadataworkBench tool Clarification

Post 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
Thanks and Regards
Vamsi krishna.v
http://datastage-vamsi.blogspot.in/
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post 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
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply