Informatica ETL开发的命名规范

 

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