how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 18962 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 we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is IQD file?
What are the basic needs to join two sources in a source qualifier?
In which transformation you cannot drag ports into it?
How many mapplets u have created? and what is the logic used
How can you validate all mappings in the repository simultaneously?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
What are ETL Tools?
Teradata 
