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

ITPub博客

Informatica ETL开发的命名规范

最新文章