Question 460
A feed changes from commas to semicolons and load fields shift unexpectedly. Which setting should be corrected?
Explanation
Correct Answer
Correct: FIELD_DELIMITER. FIELD_DELIMITER specifies the separator used between fields in delimited input.
Incorrect Answers
Not best here: SKIP_HEADER skips a specified number of leading header rows during supported CSV ingestion; the requested function is FIELD_DELIMITER.
Not best here: FIELD_OPTIONALLY_ENCLOSED_BY defines optional quote characters around field values; the requested function is FIELD_DELIMITER.
Not best here: NULL_IF specifies input string values to interpret as SQL NULL; the requested function is FIELD_DELIMITER.