Long and Thin v's Wide and Short?

AndyPainter at 18h46
27
Jul
2010
Long and Thin v's Wide and Short?

I've potentially got a 1000+ facts to store in a fact table, at a particular grain, and i'm sure that trying to create a column for each one in a fact table is not going to work, (I'd have a wide but short fact table), if i was able to do this it would make reporting easier, but i could end up creating an inflexible and costly storage structure, even if the DB systems allows it.

what i'm thinking is to create a very long but thin fact t

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Long SPX- Short NKY: Sauros isn't Soros
http://blog.thelordoftrading.com/2010/11/long-spx-short-nky-sauros-isnt-soros.html
[grad]Black Glass Navigator Bar [thin] and ranks(black)
I've made a new navigator bar based in my old one. I'm sorry but I can't edit my old post And some ranks in the same style: And a blank:
SET1/Q.3 Write a short note on economic integration in Europe.
Q.3 Write a short note on economic integration in Europe.
HF general news
Wow this is ridiculous! We definitely need to get a sovereign connection! ------- London Hedge Fund to be Backed by Libya Libya, a country that formerly supported terrorism, is investing in a London hedge fund to the tune of hundreds of millions
Ano ang pinaka murang short time motel ngayon?
queensland lang ata alam ko. kung sogo, medyo mahal.
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Long and Thin v's Wide and Short?"

This topic has been viewed 1238 times.

Last message :
27/07/2010 at 18h46 by "AndyPainter"