SCD attributes

View previous topic View next topic Go down

SCD attributes

Post  tropically on Fri Apr 13, 2012 4:47 am

Hi
Just starting on a new DW project and wanted to clarify something. For a type 2SCD, would I be correct in saying that a typical dimension would have the attributes : effective_date , end_date and current_flag, or is it just effective_date and end_date.
I apologize for the simplicity of the question.

Thanks

tropically

Posts : 13
Join date : 2009-05-12

View user profile

Back to top Go down

Re: SCD attributes

Post  BoxesAndLines on Fri Apr 13, 2012 8:51 am

I use all three. I would say that I'm typical. Others may disagree but I don't listen to them.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: SCD attributes

Post  spothr on Fri Apr 13, 2012 9:37 am

I agree too. Use all three. The cost is not that high for the ease of use later on.

spothr

Posts : 2
Join date : 2010-03-10

View user profile

Back to top Go down

Re: SCD attributes

Post  tropically on Fri Apr 13, 2012 11:37 am

Thank you guys for your feedback.

tropically

Posts : 13
Join date : 2009-05-12

View user profile

Back to top Go down

Re: SCD attributes

Post  Sponsored content


Sponsored content


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