Hi,
How do I find the list of jobs that's uses particular Transformer function. EG: AsInteger()
I don't see Transformer function being part of the object type in the standard or the advanced find.
Should we hit the UV and search for it?
If so, may I know the exact table and the column to look into to?
Thanks in advance.
Finding jobs that uses particular Transformer funtion
Moderators: chulett, rschirm, roy
I have used following query to research a similar issue. Transformer function can be parsed from text in last column i.e."expression_xmeta"
Code: Select all
SELECT a.dsnamespace_xmeta AS Project_Nm,
a.category_xmeta As Folder_Nm,
a.name_xmeta AS Job_Nm,
b.name_xmeta AS Stage_Nm,
d.name_xmeta AS Link_Nm,
e.sourcecolumn_xmeta AS Target_Col,
e.expression_xmeta AS Transformation
FROM datastagex_dsjobdefc2e76d84 a,
datastagex_dsstagec2e76d84 b ,
datastagex_dsoutputpinc2e76d84 c,
datastagex_dslinkc2e76d84 d,
datastagexdsderivationc2e76d84 e
WHERE a.xmeta_repos_object_id_xmeta = b.container_rid
AND c.container_rid = b.xmeta_repos_object_id_xmeta
AND c.xmeta_repos_object_id_xmeta = d.from_outputpin_xmeta
AND d.xmeta_lockingroot_xmeta = e.xmeta_lockingroot_xmeta;
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could use the "old" repository, which you have called UV, in which case the tables you would need to query are DS_JOBS and DS_JOBOBJECTS.
Metadata for these tables is deliberately incomplete; you may derive some benefit from searching DSXchange for examples.
Metadata for these tables is deliberately incomplete; you may derive some benefit from searching DSXchange for examples.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.