Modify Transformation Maps

Name

DME_PUB_XFORM_MAP.ModifyTransformationMap

Signature

PROCEDURE MODIFYTRANSFORMATIONMAP
(P_API_VERSION IN VARCHAR2,  P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,  P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,  P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL,  X_RETURN_STATUS OUT NOCOPY VARCHAR2,  X_MSG_COUNT OUT NOCOPY NUMBER,  X_MSG_DATA OUT NOCOPY VARCHAR2,  PIO_XFORMMAP IN OUT NOCOPY DME_XFORM_MAP_EX_OBJ_TYPE,
);

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

PIO_XFORMMAP (Mandatory). This is a parameter of DME_XFORM_MAP_EX_OBJ_TYPE object type. The attributes required for this API are:
- NAMING This is an attribute of table type CDR_NAMING_VERSION_OBJ_TYPE.
  - Company_ID To get your company ID, use CDR_PUB_DEF_FACTORY_UTILS.GetCompanyId.
  - OBJECT_TYPE_RC Enter the OBJECT_TYPE_RC as '$OBJTYPES$XFORMMAP'
  - NAMESPACE_OBJ_ID Enter the object ID of the parent in which you want to create transformation map. Parent object ID will be study ID, model map ID and table map ID for creating a model, table and column map respectively.
  - NAMESPACE_OBJ_VER Enter the parent object version in which you want to create transformation map: study version, model map version and table map version for creating a model, table and column map respectively.
- MAP_LEVEL (Mandatory) Enter either: MODEL, TABLE, or COLUMN.
- MAP_TYPE Enter Map_Type of the transformation map. It can be specified as '$MAPTYPE$DEFAULT'.
- XFORM_TYPE Enter map_Type of transformation map being modified. For table map, same of modified map type can be:
  - $XFORMTYPE$DIRECT
  - $XFORMTYPE$UNION
  - $XFORMTYPE$JOIN
  - $XFORMTYPE$CUSTOM
  - $XFORMTYPE$PIVOT
  - $XFORMTYPE$UNPIVOT
  - $XFORMTYPE$CUSTOM
    
    Tip:
    Specify the type of transformation that your custom program actually does, if possible. Use the value $XFORMTYPE$CUSTOM only if the transformation does not do any of the other transformation types. This is to support data lineage tracing.
- PROGRAM_TYPE Enter either: SYSTEM or CUSTOM.
- PROGRAM_ID Enter the program object id, if table level transformation of custom type being modified, otherwise NULL.
- PROGRAM_VER Enter the program object version, if table level transformation of custom type being modified, otherwise NULL.
- PIVOT_COLUMN_ID Enter Object Id of a Column, if table level pivot transformations being modified, otherwise NULL.
- PIVOT_COLUMN_VER Enter Object Version of a Column, if table level pivot transformations being modified, otherwise NULL.
- OPERATION_TYPE Enter operation type as '$OPER$MODIFY'.
- MAP_ENTITY_COLL This attribute is a collection of DME_MAP_ENTITY_OBJ_TYPE object type attributes. All attributes are required including identifying attributes along with required modifications. The operation_type should be passed as '$OPER$CREATE', '$OPER$MODIFY' or '$OPER$REMOVE' depending upon the modification required for a map entity.

The EXPR_OBJ_TYPE is one of the attribute in DME_MAP_ENTITY_OBJ_TYPE object type. This is a object type of DME_XFORM_EXPR_OBJ_TYPE. Pass the expression details for source filter for source tables in case of table level transformations. Refer to Create or Modify an Expression, for details.

JOIN_COLL - This is a parameter of collection type CDR_DM_JOIN_OBJ_COLL and CDR_DM_JOIN_OBJ_COLL is a table of CDR_DM_JOIN_OBJ_TYPE object type. This collection is required for modifying table level transformations of 'Join' Type.
The attributes of CDR_DM_JOIN_OBJ_TYPE required for this API, including the modifications which are required in the join condition, are:
- COMPANY_ID
- OBJ_ID
- OBJ_VER
- TABLE_NAME
- FK_TABLE_NAME
- TAB_COMPANY_ID
- TAB_OBJ_ID
- TAB_ALIAS
- TAB_MAP_ENTITY_ID
- FK_TAB_COMPANY_ID
- FK_TAB_OBJ_ID
- FK_TAB_ALIAS
- FK_TAB_MAP_ENTITY_ID
- TD_OUTERJOIN_RC
- FK_TD_OUTERJOIN_RC
- DM_JOIN_COL_OBJ_COLL

The DM_JOIN_COL_OBJ_COLL attribute is a parameter of collection type CDR_DM_JOIN_COL_OBJ_COLL, and CDR_DM_JOIN_OBJ_COLL is table of CDR_DM_JOIN_COL_OBJ_TYPE object type.

The attributes of CDR_DM_JOIN_COL_OBJ_TYPE required for this API, including the modifications which are required in the join condition, are:

COMPANY_ID
DM_JOIN_OBJ_ID
DM_JOIN_OBJ_VER
TAB_COMPANY_ID
TAB_OBJ_ID
TAB_ALIAS
TABLE_NAME
TAB_COL_COMPANY_ID
TAB_COL_OBJ_ID
TABLE_COLUMN_NAME
FK_TAB_COMPANY_ID
FK_TAB_OBJ_ID
FK_TAB_ALIAS
FK_TABLE_NAME
FK_TAB_COL_COMPANY_ID
FK_TAB_COL_OBJ_ID
FK_TABLE_COL_NAME
POSITION
JOIN_OPERATOR_RC

The JOIN_OPERATOR_RC refers to type of join condition. This can have the following values:

$JOINOPER$EQUALS
$JOINOPER$EQUALS
$JOINOPER$GREATER
$JOINOPER$GREATEREQUAL
$JOINOPER$LESS
$JOINOPER$LESSEQUAL
$JOINOPER$NOTEQUALS