About 25 minutes right now. We have about 10 stars right now and growing. I expect to have another 5 by next month.

Thanks Jonathan,

Yes, sorry, thought it was clear that the data would be coming from the operational/source system corrected.  Basically, there's a variety of drop downs that users can change after...

@jeff - thanks for your note.  Yes, I'm aware of the tenets to never update a fact.  The challenge with a lot of design theory is dealing with...

Interesting, yes, I saw Aaron's original artcile about this years ago but this is good context. We do use merge a lot. Admittedly, I've never run into problems except during...

Gotcha, that's what I thought you meant, but wanted to be sure.  I'd probably do a merge and handle it then if I go that direction.

Very much appreciated! I've been...

Thanks Chrissy,

When you say "update the fact in place while logging what was changed", can you explain what you mean? Are you updating the record with the new value?

Hi Michael,

That makes sense. I've been vacillating between that method (but also adding a current_flag or valid_flag then have the BI tool access a view with WHERE valid_flag=1)  and the...

Jeff,

Thanks for the reply.  Data types are really immaterial to the question.  I just put something together to emulate the question which is about the atomic grain; not the actual...