Informatica PowerCenter平台 ETL开发规范 mplt_change_tradeacco.$$schema_ods=ods_ods3
mplt_split_agency.$$schema_ods=ods_ods3 mplt_split_agency_ds.$$schema_ods=ods_ods3 mplt_src2odsdict.$$schema_ods=ods_ods3 mplt_ods2srcdict.$$schema_ods=ods_ods3 mplt_get_skregion.$$schema_dw=ods_dw3 mplt_tailfee.$$schema_dw=ods_dw3 mplt_managerfee.$$schema_dw=ods_dw3 mplt_agencyfare.$$schema_dw=ods_dw3 mplt_smaflag.$$schema_ods=ods_ods3 mplt_split_agency.$$dsagencyno=247 $$dsagencyno=247
[ods.WF:wf_precond_crm_call] $$srcsys=CC $$dwnframe=3 $$condtype=CALL
2. 全量加载参数文件示例：
[Global]
$$schema_downfile=ods_down3 $$schema_ods=ods_ods3 $$schema_dw=ods_dw3 $$schema_crm=htfcrm $$schema_ec=ec $$schema_hec=hec $$schema_subta=subta $$schema_selfta=selfta $$schema_yssfa=yssfa
$$schema_yssfa_ods=yssfa_ods $$schema_ysszhfa_ods=ysszhfa25_ods $$schema_ysszhfa=ysszhfa25 $$schema_oa=ecology $$schema_ips=ods_ips $$schema_fa=yssfa_ods $$schema_yssfa=yssfa $$schema_ysszhfa=ysszhfa25
Page: 11 of 39
Informatica PowerCenter平台 ETL开发规范 $DBConnection_crm=htfcrm_htfcrm_ods_172_16_4_142
$DBConnection_ods=ods2_ods_ods3_172_16_3_190 $DBConnection_dw=ods2_ods_dw3_172_16_3_190 $DBConnection_downfile=ods2_ods_down3_172_16_3_190 $DBConnection_subta=htfcrm_hsta_ods_172_16_4_142 $DBConnection_selfta=htfcrm_selfta_ods_172_16_4_142 $DBConnection_ec=htfcrm_ec_ods_172_16_4_142 $DBConnection_hec=htfcrm_hec_ods_172_16_4_142 $DBConnection_heccdc=htfcrm_hec_cdc_172_16_4_142 $DBConnection_yssfa=htfcrm_yssfa_ods_172_16_4_142 $DBConnection_ysszhfa=htfcrm_ysszhfa25_ods_172_16_4_142 $DBConnection_oa=htfcrm_ecology_ods_172_16_4_142 $DBConnection_fa=htfcrm_yssfa_ods_172_16_4_142 $DBconnection_ips=htfips_ods_ips_172_16_4_143
$ParameterFilePath=d:\\etlhome\\parameter $$ParameterFilePath=d:\\etlhome\\parameter $ParameterSqlPath=d:\\etlhome\\sqlfile $$ParameterSqlPath=d:\\etlhome\\sqlfile
mplt_getnextsk.$$schema_dw=ods_dw3 mplt_getlastwkdate.$$schema_ods=ods_ods3 mplt_getnextwkdate.$$schema_ods=ods_ods3 mplt_getnextid.$$schema_ods=ods_ods3
mplt_transform_tradetype_selfta.$$schema_ods=ods_ods3 mplt_transform_tradetype_subta.$$schema_ods=ods_ods3 mplt_change_tradeacco.$$schema_ods=ods_ods3 mplt_split_agency.$$schema_ods=ods_ods3 mplt_split_agency_ds.$$schema_ods=ods_ods3 mplt_src2odsdict.$$schema_ods=ods_ods3 mplt_ods2srcdict.$$schema_ods=ods_ods3 mplt_get_skregion.$$schema_dw=ods_dw3 mplt_tailfee.$$schema_dw=ods_dw3 mplt_managerfee.$$schema_dw=ods_dw3 mplt_agencyfare.$$schema_dw=ods_dw3 mplt_smaflag.$$schema_ods=ods_ods3 mplt_split_agency.$$dsagencyno=247 $$dsagencyno=247
Page: 12 of 39
Informatica PowerCenter平台 ETL开发规范
$$batchno=10 $$startdate=20090101 $$enddate=20100820 $$pubtheme=DC
[crmdwn.WF:wf_dwn_crm_tcustomerinfochange] $$srcsys=CC $$dwnframe=4 $$preserialno=0
3. 增量加载动态参数文件示例：
[Global]
$$schema_downfile=ods_down3 $$schema_ods=ods_ods3 $$schema_dw=ods_dw3 $$schema_crm=htfcrm $$schema_ec=ec $$schema_hec=hec $$schema_subta=subta $$schema_selfta=selfta $$schema_yssfa=yssfa
$$schema_yssfa_ods=yssfa_ods $$schema_ysszhfa_ods=ysszhfa25_ods $$schema_ysszhfa=ysszhfa25 $$schema_oa=ecology $$schema_ips=ods_ips $$schema_fa=yssfa_ods $$schema_yssfa=yssfa $$schema_ysszhfa=ysszhfa25
$DBConnection_crm=htfcrm_htfcrm_ods_172_16_4_142 $DBConnection_ods=ods2_ods_ods3_172_16_3_190 $DBConnection_dw=ods2_ods_dw3_172_16_3_190 $DBConnection_downfile=ods2_ods_down3_172_16_3_190 $DBConnection_subta=htfcrm_hsta_ods_172_16_4_142 $DBConnection_selfta=htfcrm_selfta_ods_172_16_4_142 $DBConnection_ec=htfcrm_ec_ods_172_16_4_142 $DBConnection_hec=htfcrm_hec_ods_172_16_4_142
Page: 13 of 39
Informatica PowerCenter平台 ETL开发规范 $DBConnection_heccdc=htfcrm_hec_cdc_172_16_4_142
$DBConnection_yssfa=htfcrm_yssfa_ods_172_16_4_142 $DBConnection_ysszhfa=htfcrm_ysszhfa25_ods_172_16_4_142 $DBConnection_oa=htfcrm_ecology_ods_172_16_4_142 $DBConnection_fa=htfcrm_yssfa_ods_172_16_4_142 $DBconnection_ips=htfips_ods_ips_172_16_4_143
$ParameterFilePath=d:\\etlhome\\parameter $$ParameterFilePath=d:\\etlhome\\parameter $ParameterSqlPath=d:\\etlhome\\sqlfile $$ParameterSqlPath=d:\\etlhome\\sqlfile
mplt_getnextsk.$$schema_dw=ods_dw3 mplt_getlastwkdate.$$schema_ods=ods_ods3 mplt_getnextwkdate.$$schema_ods=ods_ods3 mplt_getnextid.$$schema_ods=ods_ods3
mplt_transform_tradetype_selfta.$$schema_ods=ods_ods3 mplt_transform_tradetype_subta.$$schema_ods=ods_ods3 mplt_change_tradeacco.$$schema_ods=ods_ods3 mplt_split_agency.$$schema_ods=ods_ods3 mplt_split_agency_ds.$$schema_ods=ods_ods3 mplt_src2odsdict.$$schema_ods=ods_ods3 mplt_ods2srcdict.$$schema_ods=ods_ods3 mplt_get_skregion.$$schema_dw=ods_dw3 mplt_tailfee.$$schema_dw=ods_dw3 mplt_managerfee.$$schema_dw=ods_dw3 mplt_agencyfare.$$schema_dw=ods_dw3 mplt_smaflag.$$schema_ods=ods_ods3 mplt_split_agency.$$dsagencyno=247 $$dsagencyno=247
$$batchno=100 $$startdate=20100821 $$enddate=20100823 $$tano=47
$$pubtheme=SELFTA
[dw.WF:wf_dim_ration_sa_selfta]
Page: 14 of 39
Informatica PowerCenter平台 ETL开发规范 $$tablename=DIM_RATION_SA
[dw.WF:wf_fact_ration_agrmntcount_m_selfta] $$startdate=201006 $$enddate=201008
Page: 15 of 39