0 Replies Latest reply: Feb 1, 2013 10:26 AM by mgaspereyra RSS

    Working with a journalized table. How to retrieve only 1 row per iteration?

    mgaspereyra
      Hi all,
      I'm using ODI 11.1.1.3 and I'm a bit confused.
      I have a journalized (simple) table. This table get updated several times a day. I need to insert the new and modified rows into a target table BUT I need to run this process just one time every day. (One and only one scheduled run).
      That part was easy and clear, now I'm facing the following situation. I need fetch just the very first modified row from the journalized table, consume that change and then move to the next modified row until I've consumed all rows.
      I'm finding the way to do that.
      Can anybody help me, please?

      Thanks in advance!