Naming Convention – All Informatica Objects

Folders
The folder name should always be preceded by the application name e.g. MISDSS_Dev
Targets
The naming convention for targets (in a mapping) should be T_TargetName e.g. T_TempTrade
Mappings
The naming convention for mappings should be m_MappingName. Try giving a meaningful name to the mapping. For Ex: m_Load_Product_Datamart
Mapplets
The naming convention for mapplets should be mplt_MappletName
Sessions
The naming convention for sessions should be s_MappingName.
Sequential Batches
The naming for sequential batches should be bs_SequentialBatchName.
Concurrent Batches
The naming for concurrent batches should be bc_ConcurrentBatchName.
Log Files
LOG FILES: <session_name>.log
Bad Files
BAD FILES: <target_name>.bad
Input Ports
Input ports: prefixed with: in_, inp_, i_
Variable Ports
Variable ports: prefixed with: v_, var_
Output Ports
Output ports: prefixed with: o_, out_,
Variables
Any other type of variables like used for look-up/seq-generator/ext-procedure
Variables: look-up = v_lkp_, sequence = v_seq_, ext-proc = v_sp_
Database Connections Naming Standards
The naming for Database Connections should be <Application_Id>_<Source/Target Database>_<Environment>. For Example, MISDSS_Field_Dev

Folders

The folder name should always be preceded by the application name e.g. MISDSS_Dev

Targets

The naming convention for targets (in a mapping) should be T_TargetName e.g. T_TempTrade

Mappings

The naming convention for mappings should be m_MappingName. Try giving a meaningful name to the mapping. For Ex: m_Load_Product_Datamart

Mapplets

The naming convention for mapplets should be mplt_MappletName

Sessions

The naming convention for sessions should be s_MappingName.

Sequential Batches

The naming for sequential batches should be bs_SequentialBatchName.

Concurrent Batches

The naming for concurrent batches should be bc_ConcurrentBatchName.

Log Files

LOG FILES: <session_name>.log

Bad Files

BAD FILES: <target_name>.bad

Input Ports

Input ports: prefixed with: in_, inp_, i_

Variable Ports

Variable ports: prefixed with: v_, var_

Output Ports

Output ports: prefixed with: o_, out_,

Variables

Any other type of variables like used for look-up/seq-generator/ext-procedure

Variables: look-up = v_lkp_, sequence = v_seq_, ext-proc = v_sp_

Database Connections Naming Standards

The naming for Database Connections should be <Application_Id>_<Source/Target Database>_<Environment>. For Example, MISDSS_Field_Dev

Comments (0)

  • No comments yet.