Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Handling new grains for an existing model

2 posters

Go down

Handling new grains for an existing model Empty Handling new grains for an existing model

Post  KKumar 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

Back to top Go down

Handling new grains for an existing model Empty Re: Handling new grains for an existing model

Post  BoxesAndLines Sat Dec 24, 2011 12:33 pm

Violation sounds like a dimension to me.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

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