Fact joins twice dimension

View previous topic View next topic Go down

Fact joins twice dimension

Post  ric79 on Wed Nov 21, 2012 3:41 pm

Hi all,
I need to model this case:
1) RELATIONSHIPS between NODE_ORIGIN and NODE_DESTINATION
2) Collect daily statistics for RELATIONSHIPS

Both NODE_ORIGIN and NODE_DESTINATION are described in a single dimension called NODE.
I create a dimension called RELATIONSHIP as factless fact linking twice the NODE.
I create a fact pointing DATE and RELATIONSHIP dimensions.

Is it better to create a fact pointing direcly to NODE_ORIGIN, NODE_DESTINATION, DATE and bypass the RELATIONSHIP dimension?

Riccardo

ric79

Posts : 4
Join date : 2009-08-20

View user profile

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