scd2 effective date, end date data type

View previous topic View next topic Go down

scd2 effective date, end date data type

Post  abyss on Thu May 30, 2013 9:44 pm

hi I am new in data warehouse, I am creating a SCD2 dimension and it updates daily. just want to know the data format for effective date, end date on that table. are they should be date format? or character format? or put a number there reference from the calender_date confirm dimension table?
thanks
Howard

abyss

Posts : 8
Join date : 2013-05-27

View user profile

Back to top Go down

Re: scd2 effective date, end date data type

Post  ngalemmo on Fri May 31, 2013 12:09 pm

It is usually a date/timestamp type.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

thanks

Post  abyss on Mon Jun 03, 2013 1:42 am

thanks
Howard

abyss

Posts : 8
Join date : 2013-05-27

View user profile

Back to top Go down

Re: scd2 effective date, end date data type

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