date attributes in a conformed dimension

View previous topic View next topic Go down

date attributes in a conformed dimension

Post  dshams on Thu Aug 27, 2015 8:30 pm

Hello,
lets say I have a customer dimension(Conformed) with a customerCreateddate. In the customer fact table I map customerCreateddate. to my date dimension's SK. Now do I still need to keep this date in my customer dimension or remove it? if I remove it from the customer dimension and other fact tables need to use this dimension, then they do not get to see this attribute. My guess is to not remove it. Any thoughts?
Thanks in advanced.

dshams

Posts : 13
Join date : 2010-12-08

View user profile

Back to top Go down

Re: date attributes in a conformed dimension

Post  ngalemmo on Fri Aug 28, 2015 1:23 pm

Don't remove it.
avatar
ngalemmo

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

View user profile http://aginity.com

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