Table Comparision- SCD2

[Former Member]

Hi Experts, I have around 500 fields to Compare,i am impleted SCD2, When i update one Column is source it has to update only one column in target , but it is updating the whole row. Any Suggesions or answers please Thanks

[Former Member]

Whats there in the TC? How does the dataflow look like? Could you provide some screenshots?

[Former Member]

BODI 3.2 Using

[Former Member]

Hmm.. interesting, in most SCD2, there should be History_preserving Transform, don't see one in your data flow and current_flag is in your 'input primary key columns' ???

Not sure what you trying to do !!

[Former Member]

Hi, I have table comparision, History Priserving, Key Generation Transforms in Data flow

[Former Member]

Can you provide a screen shot of your dataflow like all of TC > HP> KG? Also do you have two keys on the target?