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
- 20154 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 |
Can you access a repository created in previous version of Informatica?
what is informatica metadata?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Hi experts, can anyone tell how much we use plsql in real time
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
What are active and passive transformations?
What is the reusable transformation?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
what is hash table in informatica?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Teradata 
