create a new record in a SCD2 for a subject that was deleted in the source system

View previous topic View next topic Go down

create a new record in a SCD2 for a subject that was deleted in the source system

Post  dierk on Wed Jul 08, 2009 7:13 am

Hi,

I have a SCD2 Customer-Dimension with more than 10 million rows. I get for each change in the source system a new row. That is OK. But I get also a new row in that moment when the Customer is deleted in the source system. Is that necessary?

Thanks

dierk

Posts : 1
Join date : 2009-07-08

View user profile

Back to top Go down

Re: create a new record in a SCD2 for a subject that was deleted in the source system

Post  ngalemmo on Thu Jul 09, 2009 12:29 am

No, probably not. It would be sufficient to add an attribute to store the date the customer was deleted and update the value in final row when a delete occurs. That is, if knowing when it was deleted is important. Otherwise, there shouldn't be a need to do anything since it would be safe to assume there would not be any future facts for that customer.
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