Pages

Sunday, March 17, 2013

Informatica Coding Standard || Informatica Naming Standard


Mappings

The naming convention for mappings which relate to specific systems could be like this:
m_<System name>_<Description>
 Example: m_np_prescriber_extracts

Mapplets

Mapplet Input
mplti_{descriptor}
Indicating the data going into the mapplet
mplti_get_detail
Mapplet Output 
mplto_{descriptor}
Indicating the data coming out of the mapplet
mplto_log_details

Workflows

Workflows should being with ‘wf_’ and represent the functionality of the workflow.
ex: Wf_np_prescriber_extarcts

Sessions

Name should be s_mapping_name 

Ex: s_ np_prescriber_extracts

Transformations 

Transformation Name
Convention
Description
Example
Aggregator
agg_

Name that describes the processing being done.
agg_sales
Expression
exp_

Describes the processing being done
exp_validate_data

External Procedure
ext_procedure_name

An external procedure transform should be a concatenation of ‘ext_’+ the name of the external procedure being called.
ext_java_db
Advanced External Procedure Transform
aep_external procedure name
Describes the advanced procedure name
aep_customer
Application Source Qualifier
Asq_{source_table1}_{source_table2} 
Represents data from application source.
asq_emp_dept
Filter
Filt_
He expression or a name that describes the processing being done.
filt_prescriber
HTTP
http_{descriptor}

http_salesforce
Java
jv_{function}
Expression or a name that describes the processing being done.
jv_item_order
Joiner
jnr_description
Source_table1_source_table2 or filename1 and filename2 if joining files
jnr_custfile_customer
Lookup
Connected
lkp_{table_name}

lkp_product
Unconnected
ulkp_{table_name}

ulkp_status
Normalizer Transformation
Nrm_{function} 
The expression or a name that describes the processing being done.
nrm_monthly_sales
Rank 
rnk_{function} 
The expression or a name that describes the ranking  being done.
rnk_monthly_sales
Router
rtr_{descriptor}

rtr_insert_update
Sequence Generator
seq_{table_name} 

seq_employee_id
Source Qualifier 
sq_{table_name} 

sq_dept
Stored Procedure
sp_{stored_procedure_name}

sp_truncate_table
Transaction Control 
tct_ or trans_{descriptor} 

trans_commit_inventory
Union

un_{descriptor}
Description of union
un_merge_transaction_records
Update Strategy 
upd_{update_type(s)} or upd_{update_type(s)}_{target_name} 

upd_existing_employees

No comments:

Post a Comment