摘自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.