datastage学习文档 - 图文

工作总结 2007 Individual 2007-10 工作总

结 1 / 65

工作总结 2007 目录 1 如何重新启动DataStage服务器, 步骤如下: ........................................................................ 5 2 DataStage开发经验积累: ...................................................................................................... 5 2.1 模板开发...................................................................................................................................... 5 2.2 通过SERVER SHARED CONTAINER在PARALLEL JOB中添加SERVER JOB STAGE ....................................... 5 2.3 去除不需要的字段 ...................................................................................................................... 5 2.4 TRANSFORMER STAGE的使用 ........................................................................................................... 5 2.5 LOOK UP/JOIN 空值处理 ............................................................................................................... 6 2.6 DATASTAGE中默认和隐式类型转换时注意的问题 ...................................................................... 6 2.7 配置一个 INPUT或OUTPUT,就VIEW DATA一下,不要等到RUN时再回头找ERROR ......................... 6 2.8 DATA型数据是比较麻烦的 .......................................................................................................... 6 2.9 行列互换之HORIZONTAL PIVOT（PIVOT STAGE） ............................................................................. 7 2.10 行列互换之VERTICAL PIVOT ......................................................................................................... 7 2.11 ORACLE EE STAGE在VIEW数据时出现的错误及解决方法 ........................................................ 9 2.12 DATASTAGE SAP STAGE的使用 ..................................................................................................... 10 2.13 COLUM IMPORT STAGE的使用 ...................................................................................................... 10 2.14 COLUM EXPORT STAGE的使用 ...................................................................................................... 12 2.15 GOT ERROR: CANNOT FIND ANY PROCESS NUMBER FOR STAGES IN JOB JOBNAME解决 ............................ 13 2.16 UNABLE TO CREATE RT_CONFIGNNN .............................................................................................. 14 2.17 查看JOB和CLIENT的对应的后台进程 .................................................................................... 14 2.18 强制杀死DS进程 ................................................................................................................... 14 2.19 查看SERVER ENGINE的进程 ...................................................................................................... 15 2.20 查看SERVER LOCKS ..................................................................................................................... 15 2.21 关于UNIX系统下无法启动服务的解决办法........................................................................ 16 2.22 LOCKED BY OTHER USER ................................................................................................................. 17 2.23 DATASTAGE JOB LOG的处理 ......................................................................................................... 17 2.24 一些BASIC语言中处理字符串的函数 .................................................................................. 17 2.25 BASIC程序中使用到的一些语法知识 ................................................................................... 18 3

DS中常见问题记录 .......................................................................................................... 22 3.1 权限管理问题 ............................................................................................................................ 22 3.2 JOB MAY BE BEING MONITORED或者是CLEANUP问题 ....................................................................... 22 3.3 删除文件的问题 ........................................................................................................................ 22 3.4 SEQUENCE调度出现的错误问题 ................................................................................................. 23 3.17 字符集问题 ............................................................................................................................. 23 3.18 VERSIONCONTROL的问题 ............................................................................................................ 23 3.19 SEQUENCE调不起JOB的问题................................................................................................... 24 3.20 SEQUENCE调度失败的问题 ....................................................................................................... 24 3.21 DS发送邮件的配置问题 ........................................................................................................ 25 3.22 随机错误问题 ......................................................................................................................... 26 3.23 DS中的日期问题 .................................................................................................................... 26 3.24 DS连接ORACLE问题 ................................................................................................................ 27

Individual 2007-10 2 / 65

工作总结 2007 3.25 在SEQUENCE FILE STAGE中的空值处理问题 .............................................................................. 27 3.26 在DS中使用ORACLE ENTERPRISE STAGE必须的权限 ................................................................. 27 3.27 DS中去除‘回车符’的问题以及从CHAR类型转变成整型的方法 .................................... 27 3.28 从后台看JOB列表的方 …… 此处隐藏：12797字，全部文档内容请下载后查看。喜欢就下载吧 ……