What should you do when datasets have fields that align to one DMO and another portion aligns to another DMO?

• A. Create formula fields
• B. Denormalize the data
• C. Use a subscriber key value
• D. Transpose the single records to multiple records

Answer: (A)

When datasets have fields that map to different DMOs, you want to create a layer that harmonizes the schema so downstream processes see a single, consistent set of fields. Formula fields let you derive the final values by referencing the source fields from each DMO and applying logic to pick or combine values as needed. This approach keeps the original data intact while producing a unified view, and it’s easy to update if formats change.

Denormalizing would duplicate data and complicate maintenance; transposing records would unnecessarily change the data structure; relying on a subscriber key value addresses identity, not field alignment across DMOs.