31

Oracle ODI 12c之多表联合查询以及定时任务设置-candon123

 6 years ago
source link: http://blog.51cto.com/candon123/2073126
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
本文介绍如何通过ODI进行多表联合查询并设置定时任务。准备工作如下：准备物理方案和逻辑方案；创建模型并通过“逆向工程”同步方案；创建项目(根据实际情况创建或者使用现有的)；确保源表和目标表都有主键存在。以上内容的前三点可以参考我博客中的相关文章。一、Preparing1.1源SQL语句SELECTa.ID,a.ORG_ID,a.NAME_ID,a.EVR_ID,a.PACKAGE_ARCH_ID,

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK