Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to implement SCD3

3 posters

Go down

How to implement SCD3 Empty How to implement SCD3

Post  KamleshKhollam 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

Back to top Go down

How to implement SCD3 Empty Re: How to implement SCD3

Post  nick_white 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 : 364
Join date : 2014-01-06
Location : London

Back to top Go down

How to implement SCD3 Empty Re: How to implement SCD3

Post  Jeff Smith 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

Back to top Go down

How to implement SCD3 Empty Re: How to implement SCD3

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum