现在的位置: 首页 > 综合 > 正文

Informatica ETL开发的命名规范

2013年09月13日 ⁄ 综合 ⁄ 共 1622字 ⁄ 字号 评论关闭
摘自Informatica联机文档, Informatica ETL开发的命名规范,实际项目中还可以考虑加上模块的名字的缩写;比较好的命名规范可以方便维护,这一点对ETL项目是十分重要的.
Informatica的开发与Datastage稍有不同,比如link, DS里面对每一个link都会有一个名字,而Informatica里面link没有名字,只有在加上条件的时候,上面才显示名称。
Suggested Naming Conventions
The following naming conventions appear throughout the PowerCenter documentation and client tools. Use the following naming convention when you design mappings and create sessions.
Transformations
Table A-1 lists the recommended naming convention for all transformations:
Table A-1. Naming Conventions for Transformations
Transformation
Naming Convention
Aggregator
AGG_TransformationName
Application Source Qualifier
ASQ_TransformationName
Custom
CT_TransformationName
Expression
EXP_TransformationName
External Procedure
EXT_TransformationName
Filter
FIL_TransformationName
Java
JTX_TransformationName
Joiner
JNR_TransformationName
Lookup
LKP_TransformationName
MQ Source Qualifier
SQ_MQ_TransformationName
Normalizer
NRM_TransformationName
Rank
RNK_TransformationName
Router
RTR_TransformationName
Sequence Generator
SEQ_TransformationName
Sorter
SRT_TransformationName
Stored Procedure
SP_TransformationName
Source Qualifier
SQ_TransformationName
Transaction Control
TC_TransformationName
Union
UN_TransformationName
Update Strategy
UPD_TransformationName
XML Generator
XG_TransformationName
XML Parser
XP_TransformationName
XML Source Qualifier
XSQ_TransformationName
Targets
The naming convention for targets is: T_TargetName.
Mappings
The naming convention for mappings is: m_MappingName.
Mapplets
The naming convention for mapplets is: mplt_MappletName.
Sessions
The naming convention for sessions is: s_MappingName.
Worklets
The naming convention for worklets is: wl_WorkletName.
Workflows
The naming convention for workflows is: wf_WorkflowName 

抱歉!评论已关闭.