Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

When to use Change dimension activity?

Avatar

Level 4

I have these cases from the preparation test and I need your help understanding "Change dimension activity".

1.- The business practicioner wants to obtain the total travel miles per recipient. Two different sets of data neeed to be combined in order to target/analyze that:

A) The first set of data contains recipient's personal info from Recipient schema.
B) The second set of data contains travel miles from the Travel schema.

The answer is: A change dimension activity is needed before merging the information in either the Travel or Recipient schemas.

At first I thought a "change dimension activity was needed because, according to the question, those tables were not linked.But in the documentation, here, it shows it is used for linked schemas?

2) In this other question, were tables are not linked, why the answer doesn't involve a Change dimension activity?

"An Adobe Campaign business practicioner is building a workflow and has been asked to use two internal Adobe Campaign schemas (tables are not linked):

A) Clients table

B) Contract Holder Table

The consultant need to select clients who have had a life-insurance policy for over 5 years. 

Which statement is true regarding the decision to choose the correct filtering and targeting dimension in Query Activity?

Using a Changing dimension activity would have been possible for this case? 


 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
2 Replies

Avatar

Correct answer by
Community Advisor

Avatar

Level 2

Hi @ogonzalesdiaz,

In the first case, a change dimension will be used if you select Travel schema as the "Targeting Dimension" while creating your query. Change dimension can be used for linked tables when you need to change the dimension from Travel schema to Recipients.

In the second case, as there is no linking between tables, you wont be able to do a change dimension. You have to link the tables to query the desired output. Dimension can be changed with the help of Reconciliation (in Enrichment).