Count of Work flow and dataflow in a single job
We would like to know the count of all the worlflow,dataflow which is present in a single job. Basically we want to know what are all the things are called in side the job and how many?
Is there any way to acheive this by seeing the repositary table or any other options are available?
So far we tried to count manually. If single job contains multiple workflow,dataflow,scripts and datastore. It is a very tough process to calculate this or find this. So if some one help us ton this ,It would be helpful for us to calculate the metrix.
Ben Hofmans replied
You should be able to get this information by querying the repository. Look for the AL_USAGE table (or ALVW_PARENT_CHILD). The Reference Guide has a chapter on "Metadata in Repository Tables and Views" that explains how to use this table (with some sample SQL).