一看就会的Informatica10.2.0.pdf

Informatica 技术超群 (QQ 群: 112443162, 92949669, 309925255) 杨晓东 作品 Page 1 of 580 Informatica 10.2.0 2019-10-18 杨晓东 著 予人玫瑰 手有余香 Informatica 技术超群 (QQ 群: 112443162, 92949669, 309925255) 杨晓东 作品 Page 2 of 580 本文目录 前言 ........................................................................................................................................................... 11 本文内容 ........................................................................................................................................... 11 本文版本 ........................................................................................................................................... 13 安装介质 ........................................................................................................................................... 14 参考文档 ........................................................................................................................................... 15 晓东作品 ........................................................................................................................................... 16 Informatica Linux Server 安装 ................................................................................................................... 17 添加 INFA 系统用户 .......................................................................................................................... 17 用户添加 ................................................................................................................................... 17 Profile 文件配置 ........................................................................................................................ 18 修改 INFA 用户 limits 值 ........................................................................................................... 19 添加 Oracle 数据库用户 ................................................................................................................... 20 调整 open_cursors 参数 ........................................................................................................... 20 创建专属 TableSpace ................................................................................................................ 20 创建数据库用户 ....................................................................................................................... 21 软件准备 ........................................................................................................................................... 23 安装 ................................................................................................................................................... 24 删除安装包 ....................................................................................................................................... 33 完善 Profile ........................................................................................................................................ 33 服务启停 ........................................................................................................................................... 34 start.sh ....................................................................................................................................... 34 stop.sh ........................................................................................................................................ 36 Informatica Window Server 安装 .............................................................................................................. 37 软件安装 ........................................................................................................................................... 37 服务启停 ........................................................................................................................................... 46 Informatica 相关服务管理 ........................................................................................................................ 47 PWC 存储库服务(PCRS) .................................................................................................................... 48 PWC 集成服务(PCIS) ......................................................................................................................... 51 PWC Web 服务中心(WSHS) .............................................................................................................. 55 PWC Metadata Manager 服务(MMS) ............................................................................................... 57 模型存储库服务(MRS) ...................................................................................................................... 61 数据集成服务(DIS) ............................................................................................................................ 63 创建数据库连接 ....................................................................................................................... 63 创建 DIS ..................................................................................................................................... 66 分析服务(AS) ..................................................................................................................................... 73 搜索服务(SS) ..................................................................................................................................... 77 内容管理服务(CMS) .......................................................................................................................... 79 监控模型存储库服务(MRS) .............................................................................................................. 81 Informatica Client 安装和简述 ................................................................................................................. 84 Window 系统上安装 Client .............................................................................................................. 84 PWC 客户端简述 ............................................................................................................................... 88 Repository Manager .................................................................................................................. 88 Designer ..................................................................................................................................... 92 Informatica 技术超群 (QQ 群: 112443162, 92949669, 309925255) 杨晓东 作品 Page 3 of 580 Workflow Manager .................................................................................................................... 93 PWC 英文界面 ........................................................................................................................... 94 Developer 客户端简述 ...................................................................................................................... 95 连接到 MRS ............................................................................................................................... 95 创建项目 ................................................................................................................................... 99 设置默认 DIS ........................................................................................................................... 101 Developer 英文界面 ................................................................................................................ 102 PWC 速成 ................................................................................................................................................. 103 Window 32-bit ODBC DSN ............................................................................................................... 103 导入源和目标对象元数据 ............................................................................................................. 106 Mapping ........................................................................................................................................... 109 创建源和目标对象实例 ................................................................................................................. 111 Session ............................................................................................................................................. 113 Worklet ............................................................................................................................................ 115 Workflow .......................................................................................................................................... 116 Workflow Monitor ........................................................................................................................... 122 Designer 中建 Workflow ................................................................................................................. 123 Workflow 调度方法 ......................................................................................................................... 126 Workflow 调度模式 ................................................................................................................. 126 pmcmd 命令调度 .................................................................................................................... 127 Command 组件调度 ................................................................................................................ 130 XML 导出导入 ................................................................................................................................. 132 Workflow 日志清理 ......................................................................................................................... 138 PCRS 管理 ........................................................................................................................................ 141 备份 ......................................................................................................................................... 141 backup.sh ......................................................................................................................... 143 删除 ......................................................................................................................................... 149 恢复 ......................................................................................................................................... 152 Alert 邮件 ........................................................................................................................................ 154 SMTP 配置 ............................................................................................................................... 154 User 订阅 ................................................................................................................................. 155 Email 例子 ............................................................................................................................... 156 任务邮件 ......................................................................................................................................... 157 Sendmail .................................................................................................................................. 157 Email Task ................................................................................................................................. 157 Session 级别 Email .................................................................................................................. 158 Salesforce 集成 ................................................................................................................................ 162 重置 SF Security Token ............................................................................................................ 162 导入 SF 结构 ............................................................................................................................ 163 SF Connection .......................................................................................................................... 165 读 SF ......................................................................................................................................... 166 写 SF ......................................................................................................................................... 167 中文解析 ......................................................................................................................................... 168 Mapping 解读 .......................................................................................................................... 168 结果验证 ................................................................................................................................. 169 Informatica 技术超群 (QQ 群: 112443162, 92949669, 309925255) 杨晓东 作品 Page 4 of 580 MySQL ODBC .................................................................................................................................... 170 MySQL 企业版 ......................................................................................................................... 170 客户端 32-bit ODBC DSN 配置 ........................................................................................ 170 MySQL 表导入 PWC ........................................................................................................ 172 服务端 ODBC 文件配置 .................................................................................................. 173 ODBC Relational Connection 配置 .................................................................................. 174 运行 Workflow ................................................................................................................. 174 MySQL 社区版 ......................................................................................................................... 175 软件下载 ......................................................................................................................... 175 安装 unixODBC ................................................................................................................ 176 安装 MySQL ODBC ........................................................................................................... 177 服务端 ODBC 文件配置 .................................................................................................. 178 完善 Profile ...................................................................................................................... 178 PWX For Hadoop .............................................................................................................................. 179 安装配置 ................................................................................................................................. 180 案例环境 ................................................................................................................................. 182 HDFS->HDFS 案例 .................................................