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.