Informatica PowerCenter 7基础培训

Informatica PowerCenter 体系结构.....................................................................4
2. Repository Server 和Informatica Server 介绍..............................................5
3. Informatica 客户端工具介绍.......................................................................................7
4. Repository Server Administration Console 介绍......................................11
4.1. 创建知识库 ................................................................................................................................. 11
4.2. 管理知识库一览 ......................................................................................................................... 13
5. Repository Manager 介绍........................................................................................14
5.1. “Repository”菜单....................................................................................................................... 14
5.2. “Edit”菜单.................................................................................................................................... 14
5.3. 对象锁(Objects Locks)............................................................................................................ 15
5.4. 元数据扩展(Metadata extensions) ..................................................................................... 15
5.5. “目录”简介.............................................................................................................................. 16
5.6. “Security”菜单............................................................................................................................. 17
5.7. “Analyze” 菜单........................................................................................................................... 18
6. Designer 介绍..................................................................................................................19
6.1. “Repository”菜单....................................................................................................................... 19
6.2. “Tools”菜单................................................................................................................................. 20
6.3. “Sources”菜单............................................................................................................................ 21
6.4. 练习 1：引入源数据库表结构............................................................................................... 21
6.5. 练习 2：引入源平面文件结构............................................................................................... 22
6.6. 练习 3：预览源数据................................................................................................................. 23
6.7. “Targets”菜单.............................................................................................................................. 24
6.8. 练习 4：自动获得目标结构.................................................................................................... 24
6.9. 练习 5：手工创建目标结构.................................................................................................... 25
6.10. 练习 6：生成目标物理表........................................................................................................ 26
6.11. 练习 7：引入目标平面文件.................................................................................................... 27
6.12. “Transformation”菜单.............................................................................................................. 27
6.13. “Mapplets”菜单........................................................................................................................... 28
6.14. “Mappings”菜单......................................................................................................................... 29
6.15. 转换组件(Transformation)简介............................................................................................ 30
6.16. 练习 8: 创建Pass Through Mapping................................................................................ 31
6.17. 练习 9: Aggregation ................................................................................................................. 33
6.18. 练习 10: Join 和Lookup ......................................................................................................... 33
7. Workflow Manager 介绍............................................................................................36
7.1. “Repository”菜单....................................................................................................................... 36
7.2. “Tools”菜单................................................................................................................................. 37