Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 OLAP Relational Structure

Author  Topic 

TallBoySings
Starting Member

2 Posts

Posted - 2005-09-28 : 13:49:18

I am building a data warehousing solution without using analysis services or OLAP or OLTP....

Dont ask why ... but I have to....


Ok so which table structure would be better ?


dimention 1|dimention 2|dimention 3|matrix 1|matrix 2|matrix 3|matrix 4....


or


dimention 1|dimention 2|dimention 3|matrix name|matrix value



I prefer the second one....

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-09-29 : 07:36:59
"....Ok so which table structure would be better ?"

that's akin to asking...."which tastes better...dog sh*t or bear sh*t"

either way your starting point is going to make it "any interesting project"
Go to Top of Page
   

- Advertisement -