[Home] [Help]
View: EDW_PVT_MAP_PROPERTIES_MD_V
View Text
SELECT MAP.ELEMENTID MAPPING_ID
, MAP.SOURCEDATAENTITY PRIMARY_SOURCE
, MAP.TARGETDATAENTITY PRIMARY_TARGET
, LINE.TEXT TEXT
, LINE.SQLTYPE TEXT_TYPE
FROM CMPRELATIONMAPPING_V MAP
, CMPWBLINE_V LINE
WHERE LINE.LINEOWNER(+)=MAP.ELEMENTID
Columns
Name |
MAPPING_ID |
PRIMARY_SOURCE |
PRIMARY_TARGET |
TEXT |
TEXT_TYPE |