PrepAway - Latest Free Exam Questions & Answers

What two techniques can be used to handle NULL values?

In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output
column. What two techniques can be used to handle NULL values? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
NullToValue(input_column,’unknown’).

B.
IF input_column = ” THEN ‘unknown’ ELSE input_column.

C.
IF input_column = NULL THEN ‘unknown’ ELSE input_column.

D.
IF IsNULL(input_column) THEN ‘unknown’ ELSE input_column.

Explanation:


Leave a Reply