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
- 20666 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 |
when informatica 8 series released ?
what are types of dimentions?
Implementation methodology
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is the difference between OLTP and ODS?
What is the use of target designer?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
What is meant by incremental aggregation?
Can anyone briefly describe abt audit table loading?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
write a query to get maximum salary from the employers table without duplicates....kindly help me
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Teradata 
