How can i insert one record in each session from a flatfile having 10 records.
need to assign numbers in targets from 1 to 10 if the number is 10 then reset it again from the next row to 1.
Not clear what you want to achieve.
What is the target system?
What do you mean by "rolling over" from 10 to 1? What value shall be "rolling over"?
Please explain with a more complete example.
Retrieving data ...