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,
Stop creation of files if the constraint does not satisfy.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Fri Oct 14, 2005 12:52 am
Stop creation of files if the constraint does not satisfy.
Yatin Mittal
Accenture Services Pvt. Ltd.
Accenture Services Pvt. Ltd.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
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
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