You are not logged in.
I have a table where it needs to have unique key each time when it is inserting a record on every ETL process. How do I achieve this in jasper ETL tool?
For example if it inserts 1,2,3 at the first run my next run should insert 4,5,6 as a key for the same set of records.
I tried NUMERIC function but it is unable to fetch a result.
Thanks lot for the update. But since its taking the last value from the look up for the next sequence there are two records getting the same key.
For example if the last value is var=5. In numeric function incremental starts from 5 again i.e Numeric sequence("s1",var,1) .So the 2nd run first value gets key as 5.
But i need it to be started with 6. How do i achieve this?