Parameter Definition Files

A parameter definition file is a file that contains one or more parameter definitions.

Parameter definition files have a .param extension.

You can create multiple .param files.

Parameter input values act as configurable constants that influence the logic of the Data Augmentation Scripts program. They provide flexibility by enabling you to adjust key values without changing the main logic of the program, as shown in this example:

DEFINE PARAMETER PARAM_SEGMENT_A_CHAR, VARCHAR2(20), "Segment A" END
DEFINE PARAMETER PARAM_SEGMENT_B_CHAR, VARCHAR2(20), "Segment B" END
 
DEFINE PRIVATE DATASET SALES_SEGMENT_F
 ROWSOURCE SO;
 THIS = SO.CUST_ID;
 THIS[TOTAL_AMT_SOLD] = SUM( SO.AMOUNT_SOLD) ;
 GROUPBY[CUST_ID];
END
 
DEFINE DATASET CUSTOMERS_SALES_SEGMENT_F
ROWSOURCE CUST INNER JOIN SALES_SEGMENT_F ON (CUST.CUST_ID = SSEG.CUST_ID);
THIS = CUST;
THIS[SALES_SEGMENT] = CASE WHEN SSEG.TOTAL_AMT_SOLD > 10000
                         THEN PARAMETER[PARAM_SEGMENT_A_CHAR]
                         ELSE PARAMETER[PARAM_SEGMENT_B_CHAR] 
                       END;
PRIMARYKEY[CUST_ID];
END