How can I order records in a JDBC query consumer

edit

I select records using a JDBC query consumer and specifically gave an 'order by' clause.

I perform JDBC lookups and 'stream selector' stages downstream.

I tried writing the processed records to a FS and to Kafka, however find that the order I selected the records from, in the first stage(JDBC query consumer) is NOT the order I got writen to the FS or Kafka.

How do I ensure the ordering is preserved at the destination?

Thank you,