Mapping Source Field Details

Displays column names for all sources by repository, folder, and mapping. It also displays properties of these columns such as datatype, precision, and length.


Click on the text to copy the query report to your clipboard.


select "SOURCE_NAME",
"REPOSITORY_NAME",
"SOURCE_FIELD_PRECISION",
"SUBJECT_AREA",
"SOURCE_FIELD_DESCRIPTION",
"SOURCE_FIELD_BUSINESS_NAME",
"SOURCE_FIELD_DATATYPE",
"SOURCE_FIELD_SCALE",
case when ("SOURCE_FIELD_NULLTYPE" = 1) then ('Yes') else ('No') end as "Calc_SOURCE_FIELD_NULLTYPE",
"SOURCE_FIELD_NAME",
"MAPPING_NAME",
"SOURCE_FIELD_KEY_TYPE"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_ALL_SOURCES.SOURCE_NAME,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_NUMBER,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_NAME,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_BUSINESS_NAME,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_DESCRIPTION as SOURCE_FIELD_DESCRIPTION,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_DATATYPE,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_PRECISION,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_SCALE,  MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_KEY_TYPE,     MAPPING_ALL_SOURCE_FLDS.SOURCE_FIELD_NULLTYPE     FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_ALL_SOURCES MAPPING_ALL_SOURCES,  REP_ALL_SOURCE_FLDS MAPPING_ALL_SOURCE_FLDS  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_WIDGET_INST.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_WIDGET_INST.  VERSION_NUMBER AND  ALL_MAPPINGS.PARENT_SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_ALL_SOURCES.PARENT_SOURCE_ID = MAPPING_ALL_SOURCE_FLDS.  PARENT_SOURCE_ID AND  MAPPING_ALL_SOURCES.PARENT_SOURCE_VERSION_NUMBER = MAPPING_ALL_SOURCE_FLDS.  PARENT_SOURCE_VERSION_NUMBER AND  MAPPING_ALL_SOURCES.PARENT_SOURCE_ID = MAPPING_WIDGET_INST.WIDGET_ID AND  MAPPING_ALL_SOURCES.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_WIDGET_INST.WIDGET_TYPE = 1 )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME"

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*