Default Value Ingestion in Adobe Experience Platform

If you need to set a default value during ingestion in Adobe Experience Platform (AEP), particularly for upsert operations, you must use explicit mappings in your data ingestion process.

Description description

Environment

Adobe Experience Platform

Issue/Symptoms

How to apply a default value during ingestion in Adobe Experience Platform?

Resolution resolution

It’s important to note that default values set in your schema are not stored during ingestion. They are applied by downstream services when data is read from the dataset.

If a default value is to be applied during ingestion, especially in the context of upsert operations, you must use explicit mappings in your data ingestion process.
Here is an example of how to apply a default value using explicit mapping:

Example:

DECODE(fieldName, null, 'default_value', fieldName)

This will set default_value when the fieldName is null during ingestion.

Follow this Experience Platform’s Experience Data Model (XDM) Guide for more details.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f