Below video explains simple DataStage job using IF THEN ELSE condition in transformer stage.
Assign a value that meets the specified conditions.If…Then…Else Operator
Syntax
variable = If condition Then expression Else expression
variable is the variable to assign.
If the condition defines the condition that determines which value to assign.
Then expression defines the value to assign if condition is true.
Else expression defines the value to assign if condition is false.
Remarks:
The If operator is the only form of If…Then…Else construction that can be used in an expression.
