Data warehouse naming conventions kimball

What is naming convention in database?
I've already stated it in the intro, but more generally, a naming convention is a set of rules you decide to go with before you start modeling your database.
You'll apply these rules while naming anything inside the database – tables, columns, primary and foreign keys, stored procedures, functions, views, etc..
I've already stated it in the intro, but more generally, a naming convention is a set of rules you decide to go with before you start modeling your database.
You'll apply these rules while naming anything inside the database – tables, columns, primary and foreign keys, stored procedures, functions, views, etc.

Jul 21, 20141. Follow naming conventions.2. Each object has one name.3. Object names are descriptive.4. Abbreviations and acronyms are discouraged.5

How do I name objects in my data warehouse / business intelligence system?

Here are my top ten suggestions for naming objects in your data warehouse / business intelligence system

1 Follow naming conventions

If you don’t have them, create (and document!) naming conventions that follow the rules in this Design Tip

If we alter the naming convention for the data warehouse it will be difficult to join back to the ODS for ad hoc follow up analysis

Some meaningful names will exceed 30 characters and will have to be abbreviated somehow

We would have to establish new rules for this abbreviation