Use stage variables in a Transformer stage to compare each row with the previous one in that column. If the direction of difference changes, then the answer is NO.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Well I highly doubt you can quit the execution of just the transformer, what you could do is as soon as there is a direction change, send it down a second link with its property set to 'Abort after 1 row'.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
The Compare stage reports direction of difference between two inputs. To use this you'd need to generate a sequential key on two copies of the sorted Data Set (Column Generator stages) with an offset of 1 between the two copies, then compare based on matching that key.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.