US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Do transformations process records in order?

  1. #1

    Default Do transformations process records in order?

    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?

  2. #2
    Join Date
    Nov 2008
    Posts
    737

    Default

    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.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •