Does anyone have a good resource or two for doing star schema fact tables,
dimenson tables, etc in an SQL Server database using T-SQL (Not Analysis
Services or MDX)?

TIA,
Bryan

You can refer to Chapter 17: "Data Warehouse Design Considerations" of
the SQL Server 2000 Resource Kit. OLAP cubes are covered at the end, but
most of the discussion is on dimensional models/star schemas:

http://www.microsoft.com/resources/d...all/reskit/en-
us/part5/c1761.mspx
Dimensional Model Schemas

The principal characteristic of a dimensional model is a set of detailed
business facts surrounded by multiple dimensions that describe those
facts. When realized in a database, the schema for a dimensional model
contains a central fact table and multiple dimension tables. A
dimensional model may produce a star schema or a snowflake schema.

Star Schemas

A schema is called a star schema if all dimension tables can be joined
directly to the fact table. The following diagram shows a classic star
schema.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

I would like to recommend you Werescape RED.

With this great BI/DWH RAD Tool you can prototype, develop and
maintain a full DWH, incl. Cubes in one place. The T/SQL code is
automatic generated.

On our website: www.gmsbv.nl you can order a free trial CD.

Regards, Marco


"Bryan Bullard" <reply (AT) to (DOT) group.com> wrote