How to implement SCD3

View previous topic View next topic Go down

How to implement SCD3

Post  KamleshKhollam on Mon Mar 10, 2014 2:57 am

If a customer is changing the address let say 5 times and if we want to store his addresses by following SCD type 3 how can we achieve it

KamleshKhollam

Posts : 1
Join date : 2014-03-10

View user profile

Back to top Go down

Re: How to implement SCD3

Post  nick_white on Mon Mar 10, 2014 4:29 am

If you want to hold the complete history of addresses you would use SCD2 not 3. SCD3 is for holding the current and previous values of a record

Regards,

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: How to implement SCD3

Post  Jeff Smith on Mon Mar 10, 2014 12:09 pm

Type 3 isn't usually used for something like addresses. Type 3 is typically used when something like "householding" is done and you need to be able to tap into follow the household ID. A "householding" process can cause existing households to be combined into one or spilt into 2 households. This can be an issue when you are trying to track the performance of a direct mail campaign. What to do when you have sent something to a Household ID that has changed several times since you did the mail out?


Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: How to implement SCD3

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