ETL Process Design – Naming Convention
I found myself modify my naming convention quite often because I am not happy with them in the first few rounds of the design process. After a while, I kind of settled with the following set of rules.
1) Prefix for different objects. This is not unique for ETL process design. But it’s very important for any SQL development work. Typically, I use the following:
tbl: for all table objects
usp: for all procedures
vw: for all views
etl: for all SSIS packages
job: for all SQL agent jobs
ix: for all indexes
2) Reserve a few verbs, nouns, and adjectives for the project. This is not unique for ETL process design either. But for any ETL development work, using the meaningful verbs, nouns, and adjectives is the foundation for a good design and also a good start for your design documentation (if anybody asks for that).
Here are some of the words I reserve for the project.