7.1 Populating tables for Composite Pipeline components

EST_OBJECT_REQUISITE table

A process or a model can have any number of prerequisites operations to run before running the process or model and any number of post-requisites after running the process or model. Hence, STSA provides a EST_OBJECT_REQUISTE table where you can maintain this list of prerequisites and post-requisites of all the selected processes and models for the composite pipeline that will be created while creating the analysis configuration.

This table has the following columns listed. Ensure that you enter the values of the prerequisites and post-requistes based on which the composite pipeline is created.

Table 7-1 Details about EST_OBJECT_REQUISITE table

Column Name Description Example Comments
V_OBJECT_INFODOM Provide the workspace name where this object is present in. STSAINFODOM Note: Ensure that all the objects are created on the same workspace or workspace.
V_OBJECT_APP_PACKAGE_ID Provide the application package ID of the process. OFS_STSA  
V_OBJECT_TYPE Provide the type of object for which prerequisite or postrequisite requisite is being configured. There are the following types of PMF and RRF objects:
  • RUNPROCESS
  • EMFNOTEBOOK
  • RN
 RUNPROCESS  
V_OBJECT_ID Provide an id or code for the following objects:
  • RUNPROCESS - id
  • RN - code
  • EMFNOTEBOOK - ID_version
 PR_1865839290  
V_REQUISITE_TYPE This represents if the required object has to run before or after the object. Provide one of the values:
  • PRE
  • POST
 POST  
V_REQUISTE_OBJECT_TYPE This is the type of the object configured for prerequisite or postrequisite.
  • BATCH
  • DATAPIPELINE
  • RN
  • RUNPROCESS
  • T2T
  • PAUSE
  • EMFNOTEBOOK
BATCH  
V_REQUISTE_OBJECT_ID This represents the unique id of the prerequisite or post requisite object. OFSAAIINFO_Data
Note: If you are providing the value in the V_REQUISITE_OBJECT_TYPE column as:
  • T2T, then mention the source details in the V_REQUISTE_OBJECT_ID column as <source_id>.<t2t_id>
  • RRF (RN), then mention the source details in the V_REQUISTE_OBJECT_ID column as <RRF_subtype>.<RRF_id>
  • PMF (RUNPROCESS), then mention the source details in the V_REQUISTE_OBJECT_ID column as <App_package_id>.<process_id>

Note: The sub-types of RRF are BR, SR and IR.

V_REQUISTE_OBJECT_SEQUENCE Provide the sequence of order to run these prerequisites and post-requisites.

Note: If same preference is given to two or more objects, they are run in parallel.

1  

EST_CONFIGURATION table

While building an analysis configuration, after selecting the metrics (process or model as a source) and additional models a composite pipeline is created.

If there is a similar composite pipeline created for an analysis configuration created earlier and it is approved, the existing pipelines are listed for selection.

Based on the models and processes selected the values in the EST_CONFIGURATION table is populated. And, this sequence is executed when the composite pipeline is executed. This is the auto sequencing mode.

Table 7-2 Details about EST_CONFIGURATION table

Column Name Description Example Comments
V_COMPONENT_CODE This represents the code of the component selected for the object. This value is prepopulated. PROCESS_AUTOSEQUENCE_MODE  
V_COMPONENT_NAME This represents the name of the object. This value is prepopulated. EST_PROCESS  
V_COMPONENT_VALUE This represents the configuration of operation. For auto-sequencing mode two options are available for selection:
  • PMF - select this option to auto-sequence based on an already existing composite pipeline where the models and pipelines are already defined.
  • DC- select this option to auto-sequence based on execution as per the glossary term mapped to published pipelines in DC.

Note:By default, the value is set to PMF. If required, you can change the value to DC.

If you are changing the source to DC then ensure that all the glossary terms are linked to the pipelines.

DC  
V_COMMENTS This represents the description of the configuration. Mode for autosequence of composite pipeline components