NAMING CONVENTIONS FOR TRANSFORMATIONS

		seq_DIM_PRODUCT
Source Qualifier Transformation	‘sq_’+ table name	If the source qualifier is defined on table DIM_PRODUCT then the transform should be named as sq_DIM_PRODUCT
Stored Procedure	‘sp_’+ stored procedure name	The stored procedure (sp) transform should be a concatenation of ‘sp_’+ the name of the stored procedurebeing called. NOTE: If a stored procedure name already begins withsp then there is no need to prefix it with ‘sp_’.
Update Strategy Transformation	‘upd_’ + table name for which update strategy is being defined	If the update strategy is being defined for column CUST_NAME then the transform should be named as upd_DIM_CUSTOMER
Union Transformation	‘un_’ + description_of_merge	un_merge_transaction_records
Router Transformation	‘rtr_’+ description_of_routing	rtr_route_wrap_error_valid_records

Ports	Naming convention to be followed
Input Ports	i_ if port is created explicitly
Output Ports	o_ if port is created explicitly
Variable Ports	v_