BookmarkSubscribeRSS Feed
Criptic
Lapis Lazuli | Level 10

Hello,

 

In the DI-Studio you can see the execution order of the transformation steps inside of a job and it even tells you that information in the little basic facts window when you click on the step. But I can't find this information anywhere in the metadata of the transformation step. All I can see is the dependencies of steps that preced/succeed the step but I ran into a problem there if a step has multiple successors.

 

Can somebody point me in the right direction where the execution order of the steps inside of a job is stored in the metadata?

 

Kind regards

Criptic

3 REPLIES 3
Criptic
Lapis Lazuli | Level 10

When I look at the metadata via metabrowse I can see Unter Job > JobActivities > Steps that the steps are listed in reverse order of the numbers but when I read the data with 

nobj6 = metadata_getnasn(uri_jobActivitie, "Steps", k, uri_jobStep);
rc5 = metadata_getattr(uri_jobStep, "Name", stepName);
rc6 = metadata_getattr(uri_jobStep, "Desc", stepDesc);
rc7 = metadata_getattr(uri_jobStep, "Id", stepID);

I get a different order.

Criptic
Lapis Lazuli | Level 10

Okay after a lot of digging I finally found my answer.

TransformationSteps have an association named Referenced Objects and in there you can find an object called ControlOrder and if you open that up you can find an XML-Defintion of the job which contains the tag <AssociatedObjects> and in there is a listing of the TransformationSteps in the right order.

 

What I'm now missing is how to access the XML of the object not just via metabrowse but via data step

isergei
Calcite | Level 5

Just faced the same problem, in case someone else needs an answer on this old question.

 

Loop the AssociatedObjects association of the ControlOrder object with metadata_getnasn() function. Comparing to the Metadata Browser the metadata_getnasn() returns the TransformationSteps in the proper order. 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1264 views
  • 0 likes
  • 2 in conversation