Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Query

Avatar

Level 2

What are Resource and Target options in " Properties " of Query ? what they do ?targeting.PNG

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi @ASNeelima 

Resource is the entity where the selection criteria will apply. In SQL mode, this corresponds to the entity set in the FROM clause

Targeting is the entity that will be returned, in SAL mode, this corresponds to the entity in the SELECT clause.

By default Targeting is the Resource entity, however if you have 0-1 or 1-1 relationship on the Resource entity, you can decide to return the entity from the relation.

For instance, if you query Delivery Logs and want to return profile, the Resource entity will be Delivery Logs while the Targeting entity will be Profile (Delivery Log has a 1-1 relationship to Profile). In the former, the count will be the number of delivery logs fitting the criteria while in the later the count will be the number of Profile fitting the criteria on the Delivery Logs.

See also the documentation: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/targetin... 

You can do a quick test to convince yourself and use Preview in the Query activity to see the differences,

Hope this helps,

Thanks

Denis

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi @ASNeelima 

Resource is the entity where the selection criteria will apply. In SQL mode, this corresponds to the entity set in the FROM clause

Targeting is the entity that will be returned, in SAL mode, this corresponds to the entity in the SELECT clause.

By default Targeting is the Resource entity, however if you have 0-1 or 1-1 relationship on the Resource entity, you can decide to return the entity from the relation.

For instance, if you query Delivery Logs and want to return profile, the Resource entity will be Delivery Logs while the Targeting entity will be Profile (Delivery Log has a 1-1 relationship to Profile). In the former, the count will be the number of delivery logs fitting the criteria while in the later the count will be the number of Profile fitting the criteria on the Delivery Logs.

See also the documentation: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/targetin... 

You can do a quick test to convince yourself and use Preview in the Query activity to see the differences,

Hope this helps,

Thanks

Denis