I am newer to the owb. i want to generate a unique number for one target column.

I tried using the mapping sequence operator.but i am not getting my desired results.

my transformations are look like

source & target tables ----> setop --> keylookup ---> expr ---> agg ---> exp --->

here i have 9246 records from the last joiner operations to load data into the target table.

so my sequence is generating from 9247 instead of 1. i want to generate from 1 .

what is the problem? i dont know how to solve it.

can any1 help me..........

thanks in advance

with regards

kesavan.r

]]>

If we forget about all (additional) qualifiers and options, a sequence in Oracle is created simply as

CREATE SEQUENCE sequence_name;

It will start from 1 and increment by 1 (though, you might have gaps between numbers) for every fetch from the sequence.

Once you reached 9246, it will - in your next operation - start from "last value + 1" which is 9247.

Therefore, either recreate the sequence (DROP and CREATE is the simplest way, although there is a way to

Please, keep in mind that this was written upon experience with sequences, NOT Oracle Warehouse Builder.]]>