how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 18174 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
How to update a particular record in target with out running whole workflow?
What are data-driven sessions?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is deployment group?
Enlist the various types of transformations.
Define sessions in informatica etl?
Explain incremental aggregation in informatica
What do you understand by SOA of Informatica?
Define joiner transformation?
What is the sequence generator transformation in informatica?
Explain the types of lookup transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
waht type of interface is used for testing the data in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to start a workflow using pmcmd command?
