Reconciliation options In Union Activity

[#1]

Please help me understand the use of below option present in Union Activity by giving example. I read the document but did not get clear idea. 

Key Only

All Shared columns

Selection of Columns

[NeelamBakre · Accepted solution]

Hello @NeelamBakre ,

Here is the description
Keys Only: Union activity will check common primary keys for the de-duplication/ reconciliation
All Shared Columns: Union Activity will check all columns for the de-duplication.

Section of columns: Union Activity will check for the selected columns for the de-deup.

[NeelamBakre · Accepted solution]

Thank You @_Manoj_Kumar ....and to use Keys Only option , we must have same columns present in all inbound transitions....right?

[_Manoj_Kumar · Accepted solution]

Yes, That's Right