Detect empty stream

Detect empty stream

This step will output one row if input stream is empty (ie when input stream does not contain any row). The output row will have the same fields as the input row, but all field values will be empty (null).

If the input stream is not empty it will not output anything.




Step name

Name of the step. This name must be unique throughout the transformation

The following design ensures always a row and can set default values when a stream is empty (sample transformation attached):