How should the data engineer create a Calculated Field that can be used to populate the eventType according to the required logic?

A data engineer is ingesting the transactional information from an ecommerce platform through a daily feed. In AEP, one Experience Event-based schema will collect the purchase events from this feed.

The eventType field of the schema must be populated with "commerce.purchases’ if in a CSV record in which the column ‘pure ha sesf arid ate’ and ‘purchaseenddate" happen on the same day, If the "purchasee/irfdate" is set to a later date, the eventType should be *commerce._orgtenant.cancer.

Both dates follow the same format "yyyy-MM-dd’T’HH:mm:ss.SSS’Z~. and the "purchaseenddate’ is always populated.

How should the data engineer create a Calculated Field that can be used to populate the eventType according to the required logic?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: D