Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What are the measure objects?

0 Answers  


Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


How to display null values on a target & non-null values on a target?

3 Answers  


WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,






How do you load alternate records into different tables through mapping flow?

0 Answers  


What is a configuration management?

1 Answers  


What are the types of presistent cache in look up tr.

0 Answers   IBM,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


what are the deliverables?in your project?

0 Answers   DELL,






Categories