Clarification Required on Union Activities in Adobe Campaign Classic

[KD1]

Hi @ParthaSarathy

Kindly help me understand the following points related to union activities in Adobe Campaign Classic:

1. Should the targeting dimensions be the same for all three reconciliation options, or just the keys only?

2. What does the option “Use common additional data only” mean when it is selected?

[ParthaSarathy]

Hi @KD1 ,

1. Yes, Both the targeting dimension must be same for 'Keys only' reconciliation.

2. Consider the input transition-1 has additional fields of @id, @email, @firstName and input transition-2 has additional fields of @id, @email, @LastName, when the option “Use common additional data only” is enabled, then the output additional data will have only the common fields. That is it will have only @id and @email.

[KD1]

Hi @ParthaSarathy 

Thank you for the reply. Regarding point one, I meant to ask whether all three reconciliation options require the same targeting dimensions, or only the keys only in the first option require the same targeting dimensions.

[KD1]

Hi @ParthaSarathy 

Kindly help with above point.

[ParthaSarathy · Accepted solution]

@KD1 ,

Keys only - All input transitions must have same targeting dimension.

All Shared columns - We can have different input targeting dimension, but both temp tables should have the primary key fields of both input schemas.

A selection of column - We can have different input targeting dimension, but atleast one field should match both the input transitions.