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




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



More Informatica Interview Questions

why dimenstion tables are denormalized in nature ?

3 Answers  


If the records doesnt satisfy the filter condition where will it go?

9 Answers   IBM,


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


can u any challenge your project?

0 Answers   HP,






How can you recover the session in sequential batches?

1 Answers  


Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  


explain abt ur project architecture?

0 Answers   Wipro, TCS, IBM, DELL, Anthem,


what is plsql table?

2 Answers  


What happens if we dont select data driven option?

2 Answers   Zensar,


how will you remove the duplicate records from flat file without using sorter?

7 Answers  


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,






Categories