Interested to Buy Any Domain ? << Click Here >> for more details...
how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 20393 Views
- CTS, I also Faced
- E-Mail Answers
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 |
How to load time dimension?
What is the difference between SOURCE and TARGET BASED COMMITS?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
in which situations do u go for starflake schema ?
What is standalone command task?
What are mapplets? How is it different from a Reusable Transformation?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Explain the difference between mapping parameter and mapping variable?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Is it possible to create multiple domains on a single Informatica server?
How to recover sessions in concurrent batches?
can we import source table without using source qualifier? if yes then how? if no then why?
Teradata 
