let $v := (
for $x in collection('/db/DRIVER/TransformationDSResources/TransformationDSResourceType')//CONFIGURATION 
let $mdId := replace(replace($x/DATA_SINK/text(), '\?type=(REFRESH|INCREMENTAL)$', ''), 'dnet://MDStoreDS/', '')
let $mdFormat := $x/SINK_METADATA_FORMAT/@name/string()
let $layout := $x/SINK_METADATA_FORMAT/@layout/string()
let $interp := $x/SINK_METADATA_FORMAT/@interpretation/string()
return
concat($mdFormat, '|', $layout, '|', $interp, '|', $x/REPOSITORY_SERVICE_IDENTIFIER/text(), '|', $mdId  ),

for $x in collection('/db/DRIVER/TransformationDSResources/TransformationDSResourceType')//CONFIGURATION 
let $mdId := replace($x/DATA_SOURCES/DATA_SOURCE/text(), 'dnet://MDStoreDS/', '')
let $mdFormat := $x/SOURCE_METADATA_FORMATS/SOURCE_METADATA_FORMAT/@name/string()
let $layout := $x/SINK_METADATA_FORMAT/@layout/string()
let $interp := $x/SINK_METADATA_FORMAT/@interpretation/string()
return
concat($mdFormat, '|', $layout, '|', $interp, '|', $x/REPOSITORY_SERVICE_IDENTIFIER/text(), '|', $mdId )

)

return distinct-values($v)