Stop creation of files if the constraint does not satisfy.

[yatin.mittal]

Hi,

I have a very simple probelm but I am not able to resolve it.
In a job, I am having a transformer stage, where I am having suppose 4 conditions based on which 4 output files will be generated. In scenarios, when my input records satisfy only 3 conditions, then the 4th file should not be created as the constraint to this file is not satisfied.
But what is happening is that it is creating an empty file.

I dont want to have that empty file.
Is there any possible solution in the job itself so that I can stop creation of files in cases where the constraints are not satisfied ?

Thanks,

[balajisr]

One solution would be to delete the file using unix shell script or commands if the file is empty. Call the uhix script from after stage subroutine or after job subroutine.

[ray.wurlod]

Indeed that, or something similar, is the ONLY solution.

You can not prevent the Sequential File stage from creating a file (provided permissions allow).

[sb_akarmarkar]

Hi,

Four output links from transformer to four output files and four condition
Then three you have fourth you want if three of any fails or all three fails....If i understand correctly then following will help

Order the links
Just use..... NOT(link1.condition1 and link2.condition2 and link3.condition3) in constraint of link4...for all three fails
NOT(link1.condition1 or link2.condition2 or link3.condition3) ....for any of fails.
No ouput no file creation... :D

Thanks,
Anupam

[chulett]

Umm... no. As noted, the Sequential stage will always create an empty file when it is 'opened' - it cannot be avoided.

If you don't want the file, check the file(s) for a zero size 'after job' and delete them if they are.