Do transformations process records in order?

[rob.emenaker]

If I have an TABLE_INPUT step with an ORDER BY clause on it, will the transformation process the records in the stream in that same order? My change data capture tables send over INSERTS, UPDATES, and DELETES and it's important that those be processed in a certain order. From some of my tests, it doesn't appear to be taking my ORDER BY into account. Am I missing something here?

[darrell.nelson]

If you have a single-path flow, the rows should stay in the order specified in the ORDER BY clause. If you have branches or parallel paths due to using Filter Rows or Switch Case Steps, the order will most likely not be maintained.