I'm using ODI 188.8.131.52 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?