how do u use sequence created in oracle in informatica? Explain with an simple

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

how do u use sequence created in oracle in informatica?
Explain with an simple example

Question Posted / shivaleela

6 Answers
20120 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / vijay

Using Stored Porcedure Transformation we can call the
Sequence Generator

Is This Answer Correct ?

5 Yes

0 No

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / vijay

By using the Stored Procedure

please corect me if am wrong

Is This Answer Correct ?

3 Yes

1 No

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / sujay

by writing sql override in the source qualifier by calling
sequence which you have created in oracle

Is This Answer Correct ?

3 Yes

2 No

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / kishore

Using SQL transformation we can call the sequence in
informatica.

Is This Answer Correct ?

1 Yes

0 No

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / nidhi

yes,Using stored procedure t/r we can do that..

I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..

while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.

If i am wrong let me knw.. Thank you

Is This Answer Correct ?

0 Yes

0 No

how do u use sequence created in oracle in informatica? Explain with an simple example..

Answer / madhavan eyunni

Hello boss, did you tried ?

Let's try, then give me exact ans... ok

Is This Answer Correct ?

0 Yes

5 No

Post New Answer