DSXchange

Posted: **Tue May 09, 2006 3:39 am**

Hi,

We have 100+ jobs in our project. Recently we discovered that we have used (unintentionally) Basic Transformers instead of Parallel Transformers in few of the jobs. We do not know which jobs are victim of this. As per my knowledge, we can check for the type of Transformer being used by generating reports of the jobs. It would be very cumbersome to generate reports for all the jobs.

Is there any quickest way to find out which jobs in my project are using Basic Transformer stages?

Thanks in advance!

Posted: **Tue May 09, 2006 8:02 am**

This is the SQL you can run at TCL. You will have to limit it to the link type of BASIC. You will need to figure that out for yourself.

Code: Select all

SELECT 
   DS_JOBOBJECTS.OLETYPE as LinkType, 
   DS_JOBS.NAME as JobName, 
   DS_JOBOBJECTS.NAME as LinkName, 
   DS_JOBS.CATEGORY as Category
FROM 
   DS_JOBOBJECTS,  
   DS_JOBS 
WHERE  
   OBJIDNO = JOBNO 
   and DS_JOBS.CATEGORY = 'whatever' 
Group by 
   LinkType, 
   JobName, 
   LinkName, 
   Category
;

Posted: **Wed May 10, 2006 4:00 am**

Found another way to see which jobs have used Basic transformer stages (or any other stages):

Go to DS Manager,
Select Stage Types -> parallel -> processing -> Basic Transformer -> Right click and select usage analysis.

DSXchange

Fetching job info

Fetching job info