       Informatica 9.6 項(xiàng)目實(shí)戰(zhàn)培訓(xùn)

01_Informatica9.6課程導(dǎo)學(xué)

02_數(shù)據(jù)倉(cāng)庫(kù)體系介紹

03_Oracle_安裝

04_Oracle_配置.wmv

05_PLSQL工具漢化破解

06_Informatica9.6安裝.wmv

07_Informatica9.6服務(wù)器配置.wmv

08_客戶端的安裝配置連接.wmv

09_客戶端工具介紹

10_源數(shù)據(jù)介紹

11_入門實(shí)例EMP_01

12_入門實(shí)例EMP_02

13_入門實(shí)例DEPT表

14_表達(dá)式Fx組件實(shí)例1

15_表達(dá)式Fx組件實(shí)例2

16_聚合組件實(shí)例

17_查找Lookup組件實(shí)例

18_過(guò)濾Filter組件實(shí)例

19_Informatica9.6 排序sort組件實(shí)例詳解

20_Informatica9.6 分發(fā)器Router組件實(shí)例

21_Informatica9.6 sql連接查詢復(fù)習(xí)

22_Informatica9.6 連接查詢同構(gòu)SQ

23_Informatica9.6 連接查詢異構(gòu)JOIN

24_Informatica9.6 等級(jí)函數(shù)Rank實(shí)例

25_Informatica9.6 數(shù)據(jù)合并Union組件實(shí)例

26_Informatica9.6 存儲(chǔ)過(guò)程Px組件實(shí)例

27_1行轉(zhuǎn)列案例sql

28_2行轉(zhuǎn)列案例ETL過(guò)程

29_工資大于該職位下平均工資案例

30_增量抽取案例

31_緩慢變化維案例

32_對(duì)文件數(shù)據(jù)的讀取寫入

33_項(xiàng)目1薪酬統(tǒng)計(jì)項(xiàng)目介紹

34_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)項(xiàng)目接口入庫(kù)ODS

35_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)項(xiàng)目EDW層明細(xì)表臨時(shí)表1sql

36_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)項(xiàng)目EDW層明細(xì)表臨時(shí)表2ETL

37_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)EDW層明細(xì)表1

38_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)EDW層明細(xì)表2

39_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)EDW層明細(xì)表3

40_Informatica 項(xiàng)目1薪酬統(tǒng)計(jì)DM層月考勤統(tǒng)計(jì)報(bào)表

41_Informatica 項(xiàng)目1開發(fā)DM層統(tǒng)計(jì)報(bào)表1

42_Informatica 項(xiàng)目1開發(fā)DM層統(tǒng)計(jì)報(bào)表2

43_Informatica 項(xiàng)目1開發(fā)DM層統(tǒng)計(jì)報(bào)表3

44_Informatica 項(xiàng)目1開發(fā)DM層薪資報(bào)表1

45_Informatica 項(xiàng)目1開發(fā)DM層薪資報(bào)表2

46_Informatica 項(xiàng)目1開發(fā)DM層薪資報(bào)表3

47_Informatica 項(xiàng)目2計(jì)費(fèi)系統(tǒng)項(xiàng)目介紹

48_Informatica 項(xiàng)目2計(jì)算系統(tǒng)項(xiàng)目ODS層

49_Informatica 項(xiàng)目2計(jì)費(fèi)系統(tǒng)EDW層1

50_Informatica 項(xiàng)目2計(jì)費(fèi)系統(tǒng)EDW層2

51_Informatica 項(xiàng)目2計(jì)費(fèi)系統(tǒng)EDW層3

52_Informatica 項(xiàng)目2計(jì)費(fèi)系統(tǒng)DM層