【正文】 ................................................................................. 9 登陸 Repository Manager .................................................................... 10 修改密碼 ............................................................................................ 10 添加外部工具 ...................................................................................... 10 DESIGNER ....................................................................................................11 登陸 Desiger....................................................................................... 12 修改密碼 ............................................................................................ 12 添加外部工具 ...................................................................................... 12 設(shè)置樣式 ............................................................................................ 12 其他選項 ............................................................................................ 14 WORKFLOW MANAGER .................................................................................. 14 登陸 WorkFlow Manager ..................................................................... 14 添加外部工具 ...................................................................................... 14 設(shè)置樣式 ............................................................................................ 15 其他選項 ............................................................................................ 15 WORKFLOW MONITOR ................................................................................... 15 登陸 WorkFlow Monitor ....................................................................... 15 4 ETL開發(fā) ............................................................................................................ 17 創(chuàng)建資料庫 ................................................................................................. 17 配置 ODBC數(shù)據(jù)源 ...................................................................................... 18 導(dǎo)入數(shù)據(jù)源表 .............................................................................................. 22 導(dǎo)入目標(biāo)源表 .............................................................................................. 26 INFORMATICA POWERCENTER使用手冊 II 創(chuàng)建 MAPPINGS ........................................................................................... 29 創(chuàng)建 WORKFLOW ......................................................................................... 31 運行 WORKFLOW ......................................................................................... 34 監(jiān)視查看運行 .............................................................................................. 34 5 轉(zhuǎn)換組件 ........................................................................................................ 36 概覽 ........................................................................................................... 36 SOURCE QUALIFIER ...................................................................................... 38 UPDATE STRATEGY ....................................................................................... 39 EXPRESSION ................................................................................................ 40 LOOKUP ...................................................................................................... 40 AGGREGATOR .............................................................................................. 41 FILTER ........................................................................................................ 42 JOINER ....................................................................................................... 42 NORMALIZER................................................................................................ 43 ROUTER .................................................................................................. 44 SEQUENCE .................................................................................................. 44 SORTER ..........................................................