A company wants to include certain personalized fields in an email by including related attributes during the activation in Data Cloud. It notices…

A batch data transform is the designated feature in Data Cloud for performing complex data cleansing, normalization, and enrichment. It allows you to read data from one or more source Data Lake Objects (DLOs), apply a series of functions (such as PROPER for casing and COALESCE for null handling), and write the transformed, clean data into a new DLO. This new DLO then serves as a reliable, normalized data source for segmentation and activation, directly addressing the company's requirements for consistent casing and default values.

1. Salesforce Help - Data Transforms in Data Cloud: "Use a data transform to cleanse and unify data from one or more data lake objects (DLOs). After you create and run the data transform, the resulting data is stored in a new DLO." This directly supports the use of a data transform to create a new, cleansed DLO.

2. Salesforce Help - Formula Expression Library in Data Cloud: This document outlines the functions available. While functions for casing and nulls exist, their primary application context is within either a Data Stream (for ingestion-time transforms) or a Data Transform. The scenario requires a post-ingestion, robust transformation, making a Batch Data Transform the superior choice for creating a new, clean data set.

3. Salesforce Help - Streaming Insights and Data Actions: "Use streaming insights and data actions to capture and act on near real-time data signals from your streaming data." This confirms that streaming insights are for event-driven processes, not batch data normalization.