Auto Map Tables

Use this API to create candidate auto Maps for table & Column transformation mappings. This operation accepts the target data model identifier object 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.AutoMapTables

Signature

PROCEDURE AUTOMAPTABLES
(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 model transformation map on which auto map has to be performed.
• PI_DATAENTITYVER (Mandatory). Enter the object Version of the model transformation map on which auto map has to be performed.