DSXchange

My job has the following format.

Seq File ------ Transformer -----Sequential file.

I put a constraint in transformer to exclude some type of data from source.

Let suppose, if all the data in source is getting rejected by my constraint in the transformer, I don't want the target file to be created.

But what is happening is, target file is anyways getting created with 0 records.


Any solution to fix this issue?

No. The file will always be created. If that 'issue' really bothers you, you can check after job and delete any zero-byte file I suppose.

oopssssssssssssss

I will go for a workaround

There is a kind of a neato hack that would work but it would involve some heavy derivation lifting and most likely is NOT worth it.

Replace the Sequential File stage with a Folder stage with a column for the file name. This would create a "late binding" effect in that the file would not be created unless the constraint on the link was met. The overwhelming problem with this is that the file would be overwritten for each row going down the output link, leaving you with only the last output row. This could be overcome however but therein lies the hack. Enough said but I will mention that if you were creating some kind of semaphore file or some other file with a single row (or wanted to create a single row with a bunch of CHAR(10)s) this technique would work.