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