小需求：批量导入Oracle数据源的字段注释到Informatica资料库

最新推荐文章于 2021-02-23 18:36:50 发布

ahua0597

最新推荐文章于 2021-02-23 18:36:50 发布

阅读量2.2k

点赞数 1

分类专栏： Informatica 文章标签： informatica 注释 Comments

本文链接：https://blog.csdn.net/ahua0597/article/details/50507418

版权

Informatica 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

小需求：批量导入Oracle数据源的字段注释到Informatica资料库

Source Table: XIE.SRC

这里写图片描述

Informatica:Souce

这里写图片描述

Oracle Scripts:
–copy Oracle Source Table Column Comments to Informatica Metadata DB
MERGE INTO dev_infa.opb_src_fld osf
USING (SELECT sub.subj_name,
src.src_id,
src.subj_id,
src.file_name,
src.source_name,
fld.fldid,
src.ownername,
fld.src_name,
comm.comments
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 all_col_comments comm
ON src.ownername = comm.owner
AND src.source_name = comm.table_name
AND fld.src_name = comm.column_name
WHERE fld.version_number = 1
AND sub.subj_name = ‘&FOLDER_NAME’
AND comm.owner = ‘&OWNER’
AND comm.table_name = ‘TABLE_NAME’) t
ON (osf.fldid = t.fldid AND osf.src_id = t.src_id AND osf.src_name = t.src_name )
WHEN MATCHED THEN
UPDATE SET osf.src_desc = t.comments;