How to load first record of first time run, Second record on 2nd time run... 3rd record on 3rd time run, to target table?
I understood your requirement as
When you load the session for the first time it has to load only 1st record. On the second run of the session it has to load 2nd record only, and so on... rit? If this is your requirement.. you can achieve this using Mapping variable concept.... Assuming EMP schema as my source..
> Desing mapping as below..
> Crete and connect nexval port to Exp-Tr and Set Seq_Gen properties as: Check on Cycle, (Be clear with properties)
> Create Mapping Variable $$Var.
> In the Exp tr Create variable port and expression as -- ' var_assign = $$Var + 1
> In the Filter Transformation write condition as Condition : seq_no = $$Var
> Connect to Target..
For the first time run $$Var will hold intial value as 1 and first record will be loaded, and $$Var will be incremented by 1 in the Exp transformation . On the second run $$Var value will become 2 and only 2nd record will be loaded into the target.. and so on..