how do u use sequence created in oracle in informatica?
Explain with an simple example
Answers were Sorted based on User's Feedback
Answer / vijay
Using Stored Porcedure Transformation we can call the
|Is This Answer Correct ?||5 Yes||0 No|
Answer / vijay
By using the Stored Procedure
please corect me if am wrong
|Is This Answer Correct ?||3 Yes||1 No|
Answer / kishore
Using SQL transformation we can call the sequence in
|Is This Answer Correct ?||1 Yes||0 No|
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
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|
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|
What are the measure objects?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
How to display null values on a target & non-null values on a target?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? email@example.com
How do you load alternate records into different tables through mapping flow?
What is a configuration management?
What are the types of presistent cache in look up tr.
How can we improve session performance in aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
what are the deliverables?in your project?