What is SCD Type 6 ,When to Use SCD Type 6

[Former Member]

Hi

What is SCD Type 6 ,When to Use SCD Type 6

Thanks in Advance

Regards

Jithendar

[SrinivasReddy · Accepted solution]

Hi Jithendar

It’s a hybrid approach, a combination of all three basic SCD techniques; hence it’s named 1+2+3 = 6. Type 6 is particularly applicable if you want to maintain complete history like Type 2 and would also like to have an easy way to effect on current version like Type 3.

Type 2: To track the historical changes as they occur.

Type 3: To include the "Current" attribute.

Type 1: Type 3 attribute is updated as Type 1 attribute.

for more  explanation  and the methods to implement SCD types in BO Data Service  with example ,Go through the following blog post

http://scn.sap.com/community/data-services/blog/2013/07/05/scd-type-implementation-in-bods

Hope that above information answers your query

Regards

Srinivas

[Former Member · Accepted solution]

Hi Srinivas

Thanks For Your Reply

Regards

Jithu