|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 20th, 2005, 01:21 PM
|
|||
|
|||
|
warehouse, starschema
ok i need some help with this.
i have 7 tables called Ord,orderline,product,client,clientvisit,salesrep,salesegion the warehouse schema is as follows: sale (in the middle) linked withL client, time, region, salesrep the question is that how do u decide on what will go in the middle?
|
|
#2
April 21st, 2005, 03:00 AM
|
||||
|
||||
|
The fact table goes "in the middle" you'll probably build it from ord and orderline.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > warehouse, starschema |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
