–query mapping source column_name
SELECT sub.subj_name,
m.mapping_name,
src.ownername,
src.source_name source_table_name,
w.instance_name instance_source_table_name,
fld.src_name column_name,
ROW_NUMBER() OVER(PARTITION BY sub.subj_name, m.mapping_name, src.source_name ORDER BY fld.fldid) position
FROM dev_infa.opb_src src
JOIN dev_infa.opb_subject sub
ON src.subj_id = sub.subj_id
JOIN dev_infa.opb_src_fld fld
ON src.src_id = fld.src_id
JOIN dev_infa.opb_mapping m
ON m.subject_id = sub.subj_id
JOIN dev_infa.opb_widget_inst w
ON m.mapping_id = w.mapping_id
AND w.widget_id = src.src_id
AND w.widget_type = 1
WHERE fld.version_number = 1
AND sub.subj_name = ‘&folder_name’
AND m.mapping_name = ‘&mapping_name’
;
–query mapping target column_name
SELECT sub.subj_name,
m.mapping_name,
tgt.target_name target_table_name,
w.instance_name instance_target_table_name,
fld.target_name column_name,
ROW_NUMBER() OVER(PARTITION BY sub.subj_name, m.mapping_name, tgt.target_name ORDER BY fld.fldid) position
FROM dev_infa.opb_targ tgt
JOIN dev_infa.opb_subject sub
ON tgt.subj_id = sub.subj_id
JOIN dev_infa.opb_targ_fld fld
ON tgt.target_id = fld.target_id
JOIN dev_infa.opb_mapping m
ON m.subject_id = sub.subj_id
JOIN dev_infa.opb_widget_inst w
ON m.mapping_id = w.mapping_id
AND w.widget_id = tgt.target_id
AND w.widget_type = 2
WHERE fld.version_number = 1
AND sub.subj_name = ‘&folder_name’
AND m.mapping_name = ‘&mapping_name’;