Otherwise option in constraints

sumesh.abraham · Post by **sumesh.abraham** » Wed Dec 17, 2008 1:40 pm

Hi,

How can use the 'Otherwise' option in constraints?

Thanks,
Sumesh

chulett · Post by **chulett** » Wed Dec 17, 2008 1:50 pm

What 'otherwise' option would that be? Do you mean perhaps an 'else' in the constraint expression? An example or more detailed question would help here.

sumesh.abraham · Post by **sumesh.abraham** » Wed Dec 17, 2008 1:57 pm

I have two output links and I've a constraint on each.

Say, for first output link, I mention that Len(cust_id)=0. If I want to write all records which fail this constraint to the other output link, instead of using a constraint such as Len(cust_id)<>0, do I have any other way to achieve the same.

chulett · Post by **chulett** » Wed Dec 17, 2008 2:04 pm

Ah... while you could mark the second as a Reject link, you probably don't want the warning that will log. For "Link2" use "Link1.REJECTED" as the constraint to catch everything that didn't go down Link1.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 17, 2008 3:34 pm

If you do not wish to use the "Reject" capability, then you need to construct a constraint expression is the logical inverse of all other output links' constraint expressions, as you have noted.