A Modify Operator is inserted at run time before a Transformer stage to handle null values

If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null.

If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected

If an input column that is used in the derivation expression of an output columncontainsa null value, then the resulting output column will be calculated ignoring the Null value.

If a restartable sequence aborts, it can be restarted from Director.

Choosing “Reset job” from Director will start the job where it left off.

Checkpoints are always added to every eligible Job Activity stage in the sequence.

There is no way to force a Job Activity stage to return if the sequence got beyond it.

Join

Merge

Modify

Funnel

Difference