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 .