Externalize Dynamic Parameters for Derived Entity Refresh Partition Executions

You may find it difficult to provide dynamic values to the parameters during the execution of the refresh partition utilities as described in the Command Line Utility for Partition-Based Derived Entities section. Hence, the application is enhanced to read Derived Entity execution parameters from the METADATA_EXECUTION_PARAMS table. Provide the required parameters in the table and the utility will pick up the utility before execution. For details, see the following illustration and table:

Example of the METADATA_EXECUTION_PARAMS Table

Figure 16-1 Example of the METADATA_EXECUTION_PARAMS Table

Table 16-14 METADATA_EXECUTION_PARAMS Table Details

Table Name	Parameter Description
V_METADATA_CODE	The DE Code.
N_METADATA_TYPE	The type is 856.
V_METADATA_INFODOM	The name of the metadata Infodom.
V_PARAM_NAME	The partition parameter type. For example, addp, delp, and filter.
V_PARAM_VALUE	The value for the partition parameter type. For example, in the preceding illustration, the value for addp is 7^8, the value for delp is 3^4 , and the value for filter is DIM_STANDARD_ACCT_HEAD_LATEST_RECORD_INDICATOR="Y".
D_RECORD_DATE	The date when the data was added or updated.

The following options are available to run the utility:

1. Run Directly from the Console
2. Run from the Operations Module