DSXchange

Hi,

I am reading a sorted sequential file and have a couple of transformers which are using keychange detection functions. I have added a dummy sort over sort keys to mark that the data is sorted but it looks like the transfomer is erasing this information on the output link.

This makes sense as a column can be modified inside transformer, is there any way to avoid inserting dummy sort stages following every transformer ?

Thanks

It should not get lost unless you have some operation on keys, are you re-partitioning etc in transformer, is the partitioning set to propagate etc. Check the score to see if its partitioning or doing something unnoticed from job design.

Nothing done on the keys, Dont think the score would report information of sort order preservance across operators.

score will report re-partition if happening before any transformer as you say. As it will partition data after reading from seq file anyways. So you have to have one sort operator just to mark that data is already sorted.