sequnce generation

hi,

in the mapping that i am working, there are two target tables and both have a column (say serial no.) where i have to just generate a sequence of numbers starting from 1 and incrementing it by 1. the problem is while i import either one sequence or multiple sequences, it does not keep the sr. nos. as same.. if the first table has 9 rows and so does the second.. the values it populates are 1 to 9 in the 1st table and 10 to 18 in the 2nd table.. also when you start the mapping again, it populates them as 19 to 27 and 28 to 36. and so on while restarts.

this is when i am using seq generators and using the next val to connect to the fields of my target tables.

please help me find alternatives to the seq generator as it is clearly not working.. also point out if i am using it incorrectly..

thanks

Create and use two different sequences for two tables.

hey thanks... had already done that :)