Friday, July 13, 2012

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_

No comments: