32CREATE TABLE &LIBREF..AGGREGATION_RULES_CONFIG (
33 TGT_TABLE_SCHEMA_NM VARCHAR(150) label =
'Target Schema Name',
34 TGT_TABLE_SCHEMA_VER VARCHAR(50) label =
'Target Schema Version',
35 TGT_TBL_VAL_COL VARCHAR(32) label =
'Target colunm',
36 TGT_TBL_ID_COL VARCHAR(32) label =
'Target Id Column',
37 TGT_TBL_ID_VAL VARCHAR(100) label =
'Target Id Value',
38 SRC_TABLE_SCHEMA_NM VARCHAR(150) label =
'Source Schema Name',
39 SRC_TABLE_SCHEMA_VER VARCHAR(50) label =
'Source Schema Version',
40 SRC_COL VARCHAR(32) label =
'Source Column',
41 SRC_WHERE_COND VARCHAR(4000) label =
'Source Where Condition',
42 SRC_WHERE_VARS VARCHAR(2000) label =
'Source Where Variables',
43 AGGREGATION_RULE VARCHAR(20) label =
'Aggregation Method',
44 WEIGHT_VAR VARCHAR(100) label =
'Weight Variable',
45 CONSTRAINT PRIM_KEY PRIMARY KEY (TGT_TABLE_SCHEMA_NM, TGT_TBL_ID_VAL, TGT_TBL_ID_COL)