CODEWITHSUNDEEP
sql-server-2008data-warehouse
Rich Andrews
Rich Andrews

Reputation: 4188

Are there any best practices around being explicit between Dimension & Fact tables in a SQL Server datawarehouse?

Im looking at implementing a dw in SQL Server 2008 and was wondering whether there is any distinct benefit/issue between using a simple table naming convention like dimMyTable, factMyOtherTable or using a schema for fact & dimensions.

Are there any any existing best practices around the naming/organising of fact & dimension tables?

Upvotes: 0

Views: 1389

Answers (1)

timcase
timcase

Reputation: 465

It isn't specific to data warehousing, but Brent Ozar had a post about using schemas and a great discussion took place in the comments.

http://www.brentozar.com/archive/2010/05/why-use-schemas/

Personally, I have always used table naming conventions (i.e., fact_orders, dim_date) instead of separate schemas.

Upvotes: 2

Related Questions