Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ77

VerifiedData Modeling and Management

Customer data was imported into a staging data extension and must be normalized before being added to the master data extension. A text field named birthday holds date values in multiple formats. Some values are valid dates, while others are not.

Which SQL keywords and functions could be used to write the query?

Explanation

ISDATE identifies whether a text value can be interpreted as a date, CASE applies conditional handling for valid versus invalid values, and CAST converts valid date text to the required date type. In Marketing Cloud Engagement SQL Query Activities, the target data extension’s update behavior is configured separately rather than written as an UPDATE statement.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!