DSXchange

Hi,

We have a oracle sequence which has to be used for three target table(Oracle) columns,How could we call oracle sequence and pass the sequence generated value to them.

Thanks for your time

Thanks,
Sateesh

Very easily. And if you search the forum you will find that that question has been answered lots of times - sometimes with examples - already.

Hi Ray,

Thanks for your suggestion and i got to know how to call sequence value in target database,But the thing is that i want to generate the unique value for all the three target table columns ,How could i achieve this.

In my target insert query i am calling oracle sequence like seq.nextval.

Thanks,
Sateesh

Three sequences.

Same as you would do it if you didn't have DataStage.