Get MappedTo Target Columns
Use this API to find all the target columns for particular source column in a table map.
Name
DME_PUB_XFORM_MAP.GetMappedToTargetColumns
Signature
PROCEDURE GetMappedToTargetColumns ( p_api_version IN NUMBER, 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, p_companyId in cdr_namings.company_id%type, pi_tabMapId in cdr_namings.obj_id%type, pi_tabMapVer in cdr_naming_versions.obj_ver%type, pi_columnId in cdr_namings.obj_id%type, pi_columnVer in cdr_naming_versions.obj_ver%type, po_targetColumnsColl OUT NOCOPY dme_char_coll );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- P_COMPANYID (Mandatory). Enter the company ID of the object.
- PI_TABMAPID (Mandatory). Enter the table map object ID.
- PI_TABMAPVER (Mandatory). Enter the table map object version.
- PI_COLUMNID (Mandatory). Enter the column object ID.
- PI_COLUMNVER (Mandatory). Enter the column object version.
- PO_TARGETCOLUMNSCOLL. Output collection of target columns in the format of Model_NAME.Table_NAME.Column_NAME.
Parent topic: Create and Modify Transformation Maps