SAP Exam C_DS_42 Topic 11 Question 52 Discussion

Actual exam question for SAP's C_DS_42 exam

Question #: 52
Topic #: 11

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.

What can you do to completely load such erroneous files?

Note: There are 2 correct answer

APlace the dataflow between a Try/Catch block to catch all erroneous rows

BUse the error handling options for conversion error in the file format definition

CSpecify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

DDefine the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

Show Suggested Answer

Suggested Answer: A, C

by Rosio at Jul 28, 2023, 06:33 PM

Limited Time Offer

25%

Off

Get Premium C_DS_42 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!