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
Sequence Generator
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
informatica.
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
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 |
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 is shared Cache. when we will use shared Cache?
difference between source based commit? and target based commit? which is better with respect to performance?
what happens if you try to create a shortcut to a non- shared folder?
Explain the tuning lookup transformation - informatica
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is powercenter on grid?
Mention few power centre client applications with their basic purpose?
what is the process we used in joiner transformation,there is no matching column in sources?
can you use flat file for repository?why?
What is joiner cache?
What are the joiner caches?