You need a list of all customers whose first name contains "Tom" and who are older than 18. Which processor should be used?

Comprehensive and Detailed Explanation:

To filter customer records based on first name containing "Tom" and age greater than 18, the Filter

processor is the correct choice.

Filter (Option C) – Correct Answer:

Explanation:

The Filter processor allows users to set conditional rules to extract only the required data.

Users can specify conditions such as:

first_name CONTAINS "Tom"

AND

age > 18

This ensures that only relevant records are included in the output.

Why not other options?

Option A (Join): Used to combine data from multiple datasets based on a key field, not for filtering.

Option B (Aggregate): Used for summarizing data, such as calculating counts, sums, or averages.

Option D (Data Sampling): Used to select a random subset of data, not for filtering based on

conditions.

Reference: Talend Pipeline Designer User Guide