how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 18680 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by a domain?
What is the function of aggregator transformation?
Differentiate between sessions and batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain transaction control transformation in informatica
What are the settings that you use to configure the joiner transformation?
How to implement security measures using repository manager?
what is the hint? how to use it to reduce the query processing in program?
How to join three sources using joiner?
Explain in detail about scd type 1 through mapping.
Differentiate between joiner and lookup transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a passive transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is substr in informatica?
