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!
Fetching job info
Moderators: chulett, rschirm, roy
Fetching job info
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.
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
;
Mamu Kim
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.
Go to DS Manager,
Select Stage Types -> parallel -> processing -> Basic Transformer -> Right click and select usage analysis.
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.