To retrieve a specific number of related records for each entry in the main targeting dimension, the correct method is to add complementary information. By choosing 'Data linked to the filtering dimension' (e.g., the transactions table), a configuration window appears. Within this window, under the "Data to be collected" tab, you can specify the "Number of lines to retrieve" (e.g., 3) and set the sort order (e.g., descending by transaction date). This directly configures the query to fetch the last three transactions for each recipient, fulfilling the requirement using a standard, built-in feature.

B. 'Data of the filtering dimension' adds more columns from the recipient table itself, not from the linked transaction table.

C. An Initialization Script is for pre-processing or setting variables before the query runs, not for defining the core data retrieval logic for linked records.

D. Switching dimensions and using aggregates is for summarizing data (e.g., total transaction count), not for retrieving a specific set of individual transaction records.

1. Adobe Campaign Classic v7 Documentation

"Query" Activity: In the section describing how to add data to a query

the process is detailed. It states

"To add data

click the Add data... link... Select... Data linked to the filtering dimension... In the Data to be collected tab

you can filter the data collected and specify the number of records to be returned." This directly supports using the "Limit the number of records to be loaded" option for the specified use case. (Source: Adobe Experience League

Campaign Classic v7 Documentation

Workflows > Targeting activities > Query).

2. Adobe Campaign Classic v7 Documentation

"Editing additional data": This section provides a specific example of collecting data based on a link. It explains how to configure the additional columns and use the "Data to be collected" tab to limit the returned rows. The documentation shows the interface where a user can select "Single row" or specify a number of lines to retrieve

along with an ordering clause

which is precisely the functionality needed to get the "last three transactions". (Source: Adobe Experience League

Campaign Classic v7 Documentation

Platform > Data model > Editing additional data).