How to implement SCD3

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

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,

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?