Load Target 10000 at a time

[CajunHere]

HELLO EveryOne,

I am using Informatica 6.2. I want to load a target table. Say Target_Table_1. Now I should populate the table 10000 rows at a time. After populating first 10000 rows the sessiion should be Paused. Now If I run the session again, The session should start loading the target from 10001 th row.

Can Anyone Helpme Out with this situation.

ThankYou.........

 

[blom0344]

My gut feeling is that it would require some sort of intermediate table with a sequence generator.
It might help if you would explain this a little bit more, what is the story behind this?

T. Blom
Information analyst
tbl@shimano-eu.com