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
