🎴 Flashcard Mode
Data Infrastructure Systems: Networking and ETL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
which one of the below is not a null handling function
AnswerClick to flip back
A
IfNull
💡 Explanation:
IfNull is primarily a SQL function (like MySQL's IFNULL), not a DataStage transformer function. DataStage uses SetNull(), MakeNull(), NullToEmpty(), IsNull(), and NullToValue() for null handling. The question tests familiarity with DataStage-specific function names versus generic SQL functions.