informatica 参数文件配置
生活随笔
收集整理的這篇文章主要介紹了
informatica 参数文件配置
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
Informatica 中 parameter file 參數文件配置規則:
參數文件的頭部內容
[Global] All Integration Services, Integration Service processes, workflows, worklets, and sessions.[Service:service name] The named Integration Service and workflows, worklets, and sessions that this service runs.[Service:service name.ND:node name] The named Integration Service process and workflows, worklets, and sessions that this service process runs.[folder name.WF:workflow name] The named workflow and all sessions within the workflow.[folder name.WF:workflow name.WT:worklet name] The named worklet and all sessions within the worklet.[folder name.WF:workflow name.WT:worklet name.WT:worklet name...] The nested worklet and all sessions within the nested worklet.[folder name.WF:workflow name.ST:session name]-or-[folder name.WF:workflow name.WT:worklet name.ST:session name]-or-[folder name.session name]-or-[session name] The named session.參數文件的內容:[HET_TGTS.WF:wf_TCOMMIT1] $$platform=windows
參數文件的標題head 只能定義一次,否則 下面的 參數信息將不起作用
[HET_TGTS.WF:wf_TCOMMIT1]$$platform=unix$DBConnection_ora=Ora2取參數文件定義的范圍越小,則此參數的值Ora3[HET_TGTS.WF:wf_TGTS_ASC_ORDR]$DBConnection_ora=Ora2[HET_TGTS.WF:wf_TGTS_ASC_ORDR.ST:s_TGTS_ASC_ORDR]$DBConnection_ora=Ora3參數文件例子
File created by RSmith 11/12/2005----------------------------------------[Service:IntSvs_01]
$PMSuccessEmailUser=pcadmin@mail.com
$PMFailureEmailUser=pcadmin@mail.com[HET_TGTS.WF:wf_TCOMMIT_INST_ALIAS]$$platform=unix[HET_TGTS.WF:wf_TGTS_ASC_ORDR.ST:s_TGTS_ASC_ORDR]$$platform=unix$DBConnection_ora=Ora2$ParamAscOrderOverride=UPDATE T_SALES SET CUST_NAME = :TU.CUST_NAME, DATE_SHIPPED = :TU.DATE_SHIPPED, TOTAL_SALES = :TU.TOTAL_SALES WHERE CUST_ID = :TU.CUST_ID[ORDERS.WF:wf_PARAM_FILE.WT:WL_PARAM_Lvl_1]$$DT_WL_lvl_1=02/01/2005 01:05:11$$Double_WL_lvl_1=2.2[ORDERS.WF:wf_PARAM_FILE.WT:WL_PARAM_Lvl_1.WT:NWL_PARAM_Lvl_2]$$DT_WL_lvl_2=03/01/2005 01:01:01$$Int_WL_lvl_2=3$$String_WL_lvl_2=ccccc本文出自 “先鋒的家園” 博客,請務必保留此出處http://jackwxh.blog.51cto.com/2850597/827607
?
總結
以上是生活随笔為你收集整理的informatica 参数文件配置的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 内存溢出和内存泄漏的区别、产生原因以及解
- 下一篇: RxAndroid2 / RxJava2