BDM - Mapping

> Data Integration Tool (ETL/ELT) > Big Data Management Informatica (BDM)

Table of Contents

Managememnt

1 - 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
Advertising

2 - Creation