Monday 17 June 2013

Standard ETL Naming Conventions For Transformation Objects


Transformation Objects
Naming Convention
Advanced External Procedure Transformation
aep_<procedure name>
Aggregator Transformation
agg_<meaningful name>
Expression Transformation
exp_< meaningful name >
Filter Transformation
fil_< meaningful name >
Joiner Transformation
jnr_<SourceTable>
Lookup Transformation
lkp_<Lookup Table Name>
Mapplet
mplt_< meaningful name >
Normalizer Transformation
nrm_< source name >
Rank Transformation
rnk_< meaningful name >
Stored Procedure Transformation
sp_<procedure name>
Union Transformation
un_<meaningful name>

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis