hi talents, how do u get sequece numbers with oracle sequence generator functi

hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???

Question Posted / baladevshree

3 Answers
7709 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / jz

If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.

Is This Answer Correct ?

6 Yes

0 No

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / santosh kumar sarangi

you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.

Is This Answer Correct ?

0 Yes

1 No

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / sukanta

You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.

You will get the solution.I check it.

Regards
Sukanta

Is This Answer Correct ?

0 Yes

3 No

Post New Answer