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.
| Author |
Topic |
|
collinsca
Starting Member
23 Posts |
 Posted - 2007-09-12 : 07:27:47
|
| A few questions:1) We have numerous fact tables with surrogate keys which reference just one dimensional surrogate key. How does this work?2) Are the ‘facts’ feeding data TO the ‘dimensions’ (back end warehousing)? Or are the ‘Dimensions’ feeding facts to the ‘facts’ tables for lookups!?Nb: Im very inexperienced at database design.Im really also using this thread to get contacts for future harder questions!Thanks kindly |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-12 : 07:45:12
|
| moved from "Site Related Discussions"_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
collinsca
Starting Member
23 Posts |
Posted - 2007-09-12 : 08:53:34
|
| where to!?thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-12 : 09:09:27
|
| to "Database Design and Application Architecture"_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
collinsca
Starting Member
23 Posts |
Posted - 2007-09-12 : 09:17:58
|
| oh yes! |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-09-12 : 09:54:31
|
quote:
Originally posted by collinsca
A few questions:1) We have numerous fact tables with surrogate keys which reference just one dimensional surrogate key. How does this work?2) Are the ‘facts’ feeding data TO the ‘dimensions’ (back end warehousing)? Or are the ‘Dimensions’ feeding facts to the ‘facts’ tables for lookups!?Nb: Im very inexperienced at database design.Im really also using this thread to get contacts for future harder questions!Thanks kindly
Is there a question?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-09-12 : 10:35:57
|
| Have a look at this [url]http://www.intelligententerprise.com/030101/602warehouse1_1.jhtml[/url] It should help you understand the basics. The fundamental concepts shouldn't be hard to grasp.Mark |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-09-12 : 21:07:31
|
| 1) We have numerous fact tables with surrogate keys which reference just one dimensional surrogate key. How does this work?Probably a star schema. A central fact table which joins to the dimensions via a single surrogate key. It is meant to make it easy for users to understand and write queries against. Some books also say it's efficient but they're incorrect.Often the sort of system you have follows the Kimball methodology (which has a lot of bad points but good marketting) so read up on that.2) Are the ‘facts’ feeding data TO the ‘dimensions’ (back end warehousing)? Or are the ‘Dimensions’ feeding facts to the ‘facts’ tables for lookups!?Probably neither.The dimensions will be populated then the fact populated with links to the dimensions. You should find natural keys on the dimensions and whe the fact table are populated these will be used to find the dimension surrogate key maybe using a current row flag on the dimension or a date. Depends on the system how this is populated but that's a common way.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
collinsca
Starting Member
23 Posts |
Posted - 2007-09-13 : 03:23:13
|
| thanks nr and mwjdavidson |
|
|
|
|
|
|
Understanding Dimension And Fact