BDM - Mapping

Managememnt

List

From the mrs repo

select * from MRX_MAPPINGS
  • Lists all the mappings and mapplets available in the Model Repository service.
-- MRX_OBJECT_SUMMARY that has information about all objects in the MRS
SELECT * FROM MRX_OBJECT_SUMMARY where object_typename like '%MappingImp%';
SELECT  object_name, to_char(new_time(to_date('1970/01/01','YYYY/MM/DD')+ numtodsinterval(last_updated_time/1000,'SECOND'),'GMT','EST'),'MM/DD/YYYY hh24:mi:ss') lst_update
FROM MRX_OBJECT_SUMMARY A,
(SELECT  mapping_id FROM MRX_MAPPINGS WHERE mapping_type = 'MAPPING') B
WHERE
A.oid = B.mapping_id

Creation

_


Powered by ComboStrap