Number of stages in a project

[koolnitz]

Hi All,

For some reason, I need to get counts of (i) no. of jobs, (ii) no. of stages, used in my project.

I know how to get the count for (i).
Is there any way to find out the count for (ii)? Of course other than opening all the jobs to count manually.

Thanks!

[kduke]

Code: Select all

Select 
   Count(*) As Cnt
From 
   DS_JOBS
Where
   NAME NOT LIKE '\%'
;

Code: Select all

Select 
   Count(*) As Cnt
From 
   DS_JOBOBJECTS
Where
   OLETYPE LIKE '%Stage'
;

[Mike]

I hope this isn't some pointy-haired manager's way of measuring productivity. They need to be careful about what they measure. It won't take long before developers start adding dozens of useless stages to jobs if that is how their productivity will be measured.

Mike

[kduke]

Mike is correct. You may want to count links, columns, routines and whatever else that takes time. Columns would be very difficult.

[koolnitz]

Kim, Thanks alot for providing the SQLs.

Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately ) DS doesn't have code in lines. So we thought of providing them the no. of jobs and stages in the project.

Do you have any better idea to measure the work done on a DS project?

Thanks guys!

[kduke]

Columns more closely relates to lines of code. Do a search on complexity. We have had several discussions on it.

[koolnitz]

How about counting the number of lines in .dsx file? Just a thought!

Next questions that might come up are..
What components to export?
Full export or job designs only?
Are we really measuring the work done (resource spent) based on this number?

I know, it's not et al intelligent, but I need to provide the measure of work done in DS in terms of lines of code

Btw, I have currently 138 jobs and 1571 stages in my project. And there are 1432320 lines in .dsx file (exported only Job designs, Shared containers and table definitions).

[ray.wurlod]

Kim, Thanks alot for providing the SQLs.

Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately ) DS doesn't have code in lines. So we thought of providing them the no. of jobs and stages in the project.

Do you have any better idea to measure the work done on a DS project?

Thanks guys!

Challenge them.

Report that number of lines of code = zero.

Let us know how they react.