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 10:01 am

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: 34
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 11:24 am

Option 1. Its a change. It doesn't matter what it is being changed to. The process is always the same.

ngalemmo

Posts: 1732
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