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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Effective and Expiry date for Dimension Default Row

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Effective and Expiry date for Dimension Default Row Empty Effective and Expiry date for Dimension Default Row

Post  ozisamur Thu Nov 20, 2014 2:46 pm

Hi guys,

As you know we are putting the record whose SK=-1, and specifies the 'Unknown' status. For that record what it should be set for effective and expiry date column?

Thanks.

ozisamur

Posts : 30
Join date : 2014-10-27

Back to top Go down

Effective and Expiry date for Dimension Default Row Empty Re: Effective and Expiry date for Dimension Default Row

Post  ngalemmo Thu Nov 20, 2014 2:50 pm

Does it really matter? Just use a very early date and a far future date.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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