1 Reply Latest reply: Feb 11, 2013 3:50 AM by Mike-Matthews-Oracle RSS

    Sorting Data before writing out

    980739
      Hi,

      I would like to sort data based on a column which will not appear in the final file i.e. a numeric row indicator. Is this possible and if so, how can it be done?

      Regards,
      Chris
        • 1. Re: Sorting Data before writing out
          Mike-Matthews-Oracle
          Hi Chris,

          No, EDQ cannot guarantee sorting due to the way we split up batches of data amongst multiple threads.

          The best way to achieve this would be to write all the data out first using an Export and then use an External Task that calls some script to apply sorting to the file. You can then call the whole operation as a job. It will likely go faster this way as well as the Export can use many threads.

          Mike