DSXchange

Hello all,

It seems my constraints on my transformer are not working correctly (or the way I think it should work).

Say for my input, I have 1000 records. I have five output links from my transformer. Below are the four constraints. The other output link is the Otherwise.
Out of the 1000 records, 68 get passed to the C4 output link. However, all 1000 records are being passed to the Otherwise link.

Can anyone shed some light as to why this would be happening and how I can resolve this?

Thanks in advance.

Only the obvious observation that none of your records meet any of the critera on the first four constraints. You would need to provide values of the tested fields in order for us to decide that one way or the other.

Thanks Ray.

However, there are records that are meeting my criteria. If you re-read above, there are 68 records that get passed to by C4 constraint. Also, all 1000 records get passed to the Otherwise link. So it seems that some records are going down two output links.

Check the output link execution order. Is the Otherwise/Log link being executed first?

Ray,

It is not the first, but it is the second condition when I open the constraints window. I am not sure how to move the order of constraints around, but I will figure it out and put the Otherwise last and see if that works.

Thanks.

Ray,

You are correct. The reason I was getting double matches was because the Otherwise link was second in order of execution. I moved the Otherwise link to last (by simply detaching and re-attaching the link to the transformer) and it ran with correct number of outputs.

I guess it never hit me that order of execution applies to constraints too.

Thanks! Marking as resolved.

There is a Link Execution Order tool in the Transformer stage toolbar.