how do u use sequence created in oracle in informatica?
Explain with an simple example
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 are the types of presistent cache in look up tr.
how to load rows into fact table in data warehouse
Describe expression transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the meaning of decode in informatica?
update strategy transformation in informatica
What is the difference between a connected look up and unconnected lookup?
What all are steps in up gradation of Informatica server?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
In informatics server which files are created during the session rums?
How to use pmcmd utility command?
What are ETL Tools?
What is a sorter transformation?
What do you mean by enterprise data warehousing?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance