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

how we load the data from source to staging area

4 Answers   TCS,


While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


Explain the difference between mapping parameter and mapping variable?

0 Answers  


Can you copy the batches?

3 Answers  


which one is better either active or passive transformation in informatica

1 Answers  






How to generate a single mapping for both the historical and incremental load.

2 Answers   TATA, CSC,


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


What is hash partition?

1 Answers  


Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,


I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  






Categories