Rules of the road:
- Users never access base tables directly. They always go through synonyms or views even if those views are simply "select *" views.
- ETL always uses staging tables that are source-specific. Use default column valeues.
- Normalize base models, but not too excess. Normalize them to a sound degree that aligns somewhere between the shource system and the downstream data.
Word Count :5,201