how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 18258 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
expain about the tune parameters?
tell me about your project functionality
How you can differentiate between connected lookup and unconnected lookup?
wat are deployement groups in informatica, how it will be used for developers
What is enterprise data warehousing?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What does refresh system mean, and what are its distinctive choice?
Differentiate between sessions and batches?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to use pmcmd utility command?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
what is INFORMATICA TESTING process
Write the advantages of partitioning a session?
As union transformation gives UNION ALL output, how you will get the UNION output?
