Ardent DataStage 核心开发人员指南.doc

该【Ardent DataStage 核心开发人员指南 】是由【夜紫儿】上传分享，文档一共【285】页，该文档可以免费在线阅读，需要了解更多关于【Ardent DataStage 核心开发人员指南 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。-8187iPublishedbyInformix?PressInformixCorporation4100BohannonDriveMenloPark,CA94025-1032?1997–,oneormoreofwhichmayberegisteredintheUnitedStatesorotherjurisdictions:Ardent?;Ardent?DataStage?;DataStage?;Informix?;MetaBroker?;MetaStage?;UniData?;UniVerse?.,,Windows,andWindowsNTareregisteredtrademarksofMicrosoftCorporationintheUnitedStatesand/,licensedexclusivelythroughX/pany,:MandydeBelinGOVERNMENTLICENSERIGHTSSoftwareanddocumentationacquiredbyorfortheUSGovernmentareprovidedwithrightsasfollows:(1)ifforcivilianagencyuse,withrightsasrestrictedbyvendor’sstandardlicense,;(2),withrightsasrestrictedbyvendor’sstandardlicense,unlesssupersededbyanegotiatedvendorlicense,..............................................................................................................i本书的组织..........................................................................................i文档约定惯例.....................................................................................ii用户界面的约定........................................................................ivDataStage相关文档............................................................................v1-第一章介绍............................................................................1-1关于数据仓库..................................................................................1-1操作数据库与数据仓库..........................................................1-2构造数据仓库..........................................................................1-2数据仓库定义..........................................................................1-3抽取数据抽取..........................................................................1-3数据聚集..................................................................................1-3数据转换..................................................................................1-4数据仓库的优点......................................................................1-4DataStage的主要特点.....................................................................1-42-第二章关于DataStage...........................................................2-1DataStage是怎样被包装的.............................................................2-1客户端组件..............................................................................2-1服务器端组件..........................................................................2-2DataStage项目.................................................................................2-2DataStage作业.................................................................................2-3DataStageNLS.................................................................................2-4字符映射表和地域..................................................................2-4DataStage术语与概念.....................................................................2-53-第三章你的第一个DataStage项目......................................3-1建立你的项目..................................................................................3-2iii启动DataStageManager..........................................................3-2定义表的定义..........................................................................3-4创建一个作业..................................................................................3-7开发一个作业..................................................................................3-9添加地域................................................................................3-10连接各个地域........................................................................3-11编辑各个地域................................................................................3-12编辑UniVerse地域..............................................................3-12编辑Transformer地域..........................................................3-16编辑SequentialFile地域......................................................3-21编译作业................................................................................3-23运行作业................................................................................3-24分析你的数据仓库................................................................3-254-第四章创建一个项目............................................................4-1DataStageManager...........................................................................4-2开始DataStageManager..........................................................4-3DataStageManager窗口..........................................................4-4使用DataStageManager..........................................................4-8选择一个可选的项目............................................................4-12定制工具栏............................................................................4-13DataStageManager选项........................................................4-15退出DataStageManager........................................................4-15表的定义........................................................................................4-15TableDefinition对话框.........................................................4-16导入表的定义........................................................................4-22手工输入表定义....................................................................4-24查看或修改表定义................................................................4-32使用DataBrowser.................................................................4-34存储过程定义................................................................................4-36导入存储过程定义................................................................4-37ivArdentDataStage核心开发人员指南关于存储过程的TableDefinition对话框............................4-37手工输入存储过程定义........................................................4-40查看或更改存储过程的定义................................................4-43数据元素........................................................................................4-44创建数据元素........................................................................4-45分配数据元素........................................................................4-47查看或编辑数据元素............................................................4-48内置数据元素........................................................................4-49主机机器说明................................................................................4-505-第五章开发作业....................................................................5-1DataStageDesigner..........................................................................5-1启动DataStageDesigner..........................................................5-2DataStageDesigner窗口..........................................................5-3保存作业................................................................................5-10打开一个作业........................................................................5-12退出DataStageDesigner........................................................5-13地域................................................................................................5-13服务器作业地域....................................................................5-14主机作业地域........................................................................5-15容器................................................................................................5-17创建一个容器........................................................................5-17添加一个容器地域................................................................5-18察看或修改一个容器............................................................5-18使用输入和输出地域............................................................5-18连接................................................................................................5-20连接服务器地域....................................................................5-20连接主机地域........................................................................5-22连接排序................................................................................5-24v开发作业设计................................................................................5-25增加地域................................................................................5-25移动地域................................................................................5-26从DesignerCanvas重命名地域...........................................5-27删除地域................................................................................5-27连接地域................................................................................5-28编辑地域................................................................................5-29使用DataBrowse...................................................................5-35编译服务器作业....................................................................5-38为主机作业生成代码............................................................5-40作业属性........................................................................................5-44服务器作业属性....................................................................5-44指定服务器作业的参数........................................................5-47作业控制过程........................................................................5-52指定作业相关性....................................................................5-56指定映射和地域....................................................................5-59指定主机作业参数................................................................5-62指定Designer选项........................................................................5-65缺省选项................................................................................5-66打印机选项............................................................................5-67提示选项................................................................................5-68ExpressionEditor选项...........................................................5-68JobRunOptions对话框................................................................5-706-第六章DataStage编程...........................................................6-1服务器作业编程..............................................................................6-1ExpressionEditor......................................................................6-2编程组件..................................................................................6-2过程..........................................................................................6-3转换..........................................................................................6-4函数..........................................................................................6-5viArdentDataStage核心开发人员指南表达式......................................................................................6-5子过程......................................................................................6-6宏..............................................................................................6-6主机作业编程..................................................................................6-6表达式......................................................................................6-7过程..........................................................................................6-87-第七章UsageAnalysis............................................................7-1使用UsageAnalysis工具...............................................................7-1DataStageUsageAnalysis窗口..............................................7-2可见关系..........................................................................................7-6配置警告..........................................................................................7-7察看HTML报告...............................................................