Informatica PowerCenter Parameter file 中的参数影响范围 与 参数文件举例

【转】Informatica PowerCenter Parameter file 中的参数影响范围 与 参数文件举例

Heading

Scope

[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.

上面的表格是参数影响范围的介绍。

-------------------------------------------

下面是一个参数文件的例子

Sample Parameter File

The following text is an excerpt from a parameter file that contains service variables for one Integration Service and parameters for four workflows:

----------------------------------------

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