Find Generated Transformations' ID/URI used in a given job.

caeduspl — Tue, 18 Oct 2022 11:36:49 GMT

Hello I am developing a tool which analyse metadata dependencies in DI Studio Jobs.

Let's say I have a Generated Transformation (Prototype) object with an ID AAA.BBB and I used it in many jobs AAA.XXX (id) included.

Via analysing associations I was able to find used PhysicalTable, ExternalTable and Job (subjobs) objects used in a AAA.XXX job.
I achieved that using Job --> CustomAssociations --> ControlOrder --> AssociatedObjects path.

I am in fact able to get a TransformationStep object (AAA.YYY id) which implements AAA.BBB Generated Transform (Prototype) yet its still not the AAA.BBB ID found.
Let's go further AAA.YYY has interesting associations: Transformations and UsingPrototype.
Transformations leads to a Steps association returning object which is the TransformationStep - its a AAA.YYY again. Its a dead end.

UsingPrototype is promising. I get the Prototype type object AAA.ZZZ (note its not the AAA.BBB I am looking for). Furthermore it doesnt have a name in the attributes and I cannot resolve it path in DI folder tree. It has a UsedByPrototypes association but it drives me back to TransformationSteps so a dead end again.

Is there anyway to pinpoint Generated Transforms used in a DI Job?
I would preferably stick to data step functions

metadata_getnasl
metadata_getnasn
metadata_getnatr

because I am already familiar with them.

Best regards and thank you!

Max

Re: Find Generated Transformations' ID/URI used in a given job.

caeduspl — Wed, 19 Oct 2022 13:04:32 GMT

Problem solved: both TransformationStep and the valid Prototype (Generated Transform in DI) have Class property.

You can get it by:

metadata_getprop(TransStepURI, 'Class', Class);

And find the transformation in the repository with the same Class property value.

topic Re: Find Generated Transformations' ID/URI used in a given job. in SAS Programming

Find Generated Transformations' ID/URI used in a given job.

Re: Find Generated Transformations' ID/URI used in a given job.