Auto Map Columns

Use this API to create candidate auto Maps for Column transformation mappings. This operation accepts the target table object identifier details as parameter for which auto maps has to be generated. The API creates the potential auto maps based on Oracle Name, Data Type & Length and Alias Match.

Name

DME_PUB_XFORM_MAP.AutoMapColumns

Signature

PROCEDURE AUTOMAPCOLUMNS
( 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,    PI_DATAENTITYID IN CDR_NAMING_VERSIONS.OBJ_ID%TYPE,    PI_DATAENTITYVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE
);

Parameters

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

• PI_DATAENTITYID (Mandatory). Enter the object Id of the target table on which auto map has to be performed.
• PI_DATAENTITYVER (Mandatory). Enter the object Version of the target table.