What Impact do dimensions have that actually are facts ?

View previous topic View next topic Go down

What Impact do dimensions have that actually are facts ?

Post  Oleole on Tue Dec 11, 2012 4:18 pm

Hi !

I have investigated several new dimensions that are actually fact tables (mostly factless ?) in our system.
It's in the insurance indstry, and some dimensions have both objects and coverages in the same (dimension/factless-fact-table), (one table even have policies objects and coverages included).
Is it still possible to put these tables to good use, and what will the side-effects be using these ? (I have a hard time telling what problem this might cause)

Looking forward to description of "The Road to Hell" ?

Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: What Impact do dimensions have that actually are facts ?

Post  BoxesAndLines on Tue Dec 11, 2012 10:00 pm

You can continue to use them as facts with no reservations. I wouldn't add them as dimensions to any new existing facts.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

What would happen

Post  Oleole on Wed Dec 12, 2012 4:44 am

What would happen if these tables are added to new fact tables ?

Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: What Impact do dimensions have that actually are facts ?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum