Much ado about overlapping type 2 change

View previous topic View next topic Go down

Much ado about overlapping type 2 change

Post  cjrinpdx on Wed Aug 31, 2011 1:01 pm

Let's say we have an employee dimension with a last name attribute. Last name is a type 2.

The employee gets married, triggering a type 2 change (last name) and creates a new record.
Let's say the same employee gets divorced (sorry), triggering a type 2 change (last name changes back to maiden name).

What should we do?
1) Trigger another type 2 change, and create a new record.
2) Reactivate the old record (change RowIsCurrent = True)

cjrinpdx

Posts : 51
Join date : 2011-07-14
Location : Portland, OR

View user profile

Back to top Go down

Re: Much ado about overlapping type 2 change

Post  ngalemmo on Wed Aug 31, 2011 2:24 pm

Option 1. Its a change. It doesn't matter what it is being changed to. The process is always the same.
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