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

"Perfect" design vs. Time to Implement

3 posters

Go down

"Perfect" design vs. Time to Implement Empty "Perfect" design vs. Time to Implement

Post  DanColbert Fri Jul 31, 2009 10:41 am

How difficult would it be to implement a new dimension on an existing fact table?

I have a situation where the time I have to launch a business process is shorter than the time I need to get a new dimension designed and pushed. I'm thinking about implementing the process without that new dimension and adding it later.

What are the pitfalls I can expect if I choose this rout?

Thanks in advance!

Dan
DanColbert
DanColbert

Posts : 11
Join date : 2009-02-03
Age : 54

Back to top Go down

"Perfect" design vs. Time to Implement Empty Re: "Perfect" design vs. Time to Implement

Post  ngalemmo Fri Jul 31, 2009 11:08 am

It can be very time consuming to add a new dimension after the fact. Normally you would need to reprocess all historical facts to get the dimension keys right on what was already there. It may not be practical.

A better solution is to simply stub the dimension table. Assuming your fact data feed has the natural key you need for the dimension, why not design the table to contain just the primary and natural keys? Then the fact process can infer dimension rows as new natural keys come in, and the fact foreign key will contain the appropriate surrogate key value to reference the proper row. Later, when the dimension itself is properly designed and the data feed resolved, you just need to implement the dimension update process... no need to go back and re-key the facts.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

"Perfect" design vs. Time to Implement Empty Re: "Perfect" design vs. Time to Implement

Post  BoxesAndLines Sat Aug 01, 2009 11:09 am

It is certainly a bridge you will have to cross sooner or later. As ngalemmo pointed out, the most difficult aspect is dealing with history. If you don't need to populate history, which is often not even a choice, the enhancement is not difficult.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

"Perfect" design vs. Time to Implement Empty Re: "Perfect" design vs. Time to Implement

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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