Handling new grains for an existing model

View previous topic View next topic Go down

Handling new grains for an existing model

Post  KKumar on Thu Dec 22, 2011 10:14 pm

I have this ER model which has parent-child relationship that is too deep
Project -< Project Bldg -< Bldg Inspection -< Inspection Results

Since the grain in this case is the inspection results which cannot be broken down further, we build one fact table and all the dimensions. A year later the business process is enhanced to have one more child table to the flow. So now the ER model looks like

Project -< Project Bldg -< Bldg Inspection -< Inspection Results-< Violation

Now the grain in this case is the Violation. Does this mean that I have to build one more fact table or modify the existing fact table to accommodate this change?

Thanks


KKumar

Posts : 22
Join date : 2011-07-29

View user profile

Back to top Go down

Re: Handling new grains for an existing model

Post  BoxesAndLines on Sat Dec 24, 2011 12:33 pm

Violation sounds like a dimension to me.
avatar
BoxesAndLines

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

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