DSXchange

Since dataset doesn't get created when no records are written to it due to constraints in transformer (or any other stage).

What would be the best approach to create an empty dataset? As this should be called in multiple jobs with dataset name as an argument.

With a policy of create or overwrite, you should still get a zero rows dataset, even if no qualifying rows are output.

tostay2003 wrote:Since dataset doesn't get created when no records are written to it due to constraints in transformer (or any other stage).

This is not correct.