DataStage基础培训教程

Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Click to edit Master title style,*,单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,*,DataStage根底培训,Jerry,2006.03,议程,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,2,演示：,Hello World,E,xtract,T,ransform,L,oan,3,Hello World,DataStage,Components,Define Parameters&Tables,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,4,DataStage Architecture,Target,(Database or File),ODBC/Native,DataStage Connect API,DataStage Server,(WinNT,Win2000 or UNIX),ODBC/Native,Data Sources(Database or File),DataStage Connect API,DataStage Connect API,DataStage Connect API,Data flow,Data flow,5,DataStage Components,Manager,Designer,Director,Metadata collection and management,Design process flow,Run jobs,check logs and set schedules,DataStage,Administrator,Create,Edit projects,6,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,7,全局变量与,Job,变量,全局变量,-,生命周期：整个,Project,-,在,Administrator,中定义,Job,变量,-,生命周期：一个,Job,-,在,Designer,、,Manager,中定义,8,演示：定义一个,Job,变量,在,Designer,中定义参数,9,Meta data definition,元数据管理的重要组成局部,在Manger或Design中定义,演示：,-import from a flat file in.txt format,-import from an DBMS table,10,演示,Table Definition,在,Manage,中定义,Table,11,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,12,演示：生成事实表,明细表,事实表,关联,聚合,13,Hash File,用途：,-左连接时用作副表,-屡次被访问的数据集,-存储其他临时数据,关键点：,-必须指定key,-output的position必须与input一致,14,Transformer,用途：,-提供丰富的运算符和函数,-数据清洗、转换,-关联多个数据源,关键点：,-副表的key必须被主表的某个字段关联,-尽量防止两个Transformer直接相连,15,Aggregator,用途：,-,Sum,Max,Min,Average,等聚合函数,-,一般用于生成事实表,16,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,17,Debug and Tuning,View Status and Logs,-status,log,detail,等多种视图,-,配合,Monitor,来查错、调优,18,Job Status,Not Compiled,Compiled,Reset,Running,Finished,Finished(with warning),Abort,19,Schedule,Job,Add to Schedule,20,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,21,Administrator,Add a new project,Modify project properties,-字符集,-日志保存天数,-hash file and write catch,Define environment viable,22,Manager,Import and export projects or jobs,-,两种文件格式：,.dsx .xml,-,整个,project,根据,category,Table definition,Manage Routine,23,演示：备份project,24,Hello World,DataStage,Components,Define Parameter&Table,Hash File,、,Transformer,、,Aggregator,Director&Monitor,Administrator&Manager,Routine&Control,议程,25,Routine,一种自定义函数，使用,VB,语法,-Transformer Routine,-Before/After Subroutine,系统内置了丰富的,Routine,演示：定义一个,Transformer Routine,26,Job Control,在一个,Job,中调度其他,Job,27,Q&A,Thanks!,28,