how do u use sequence created in oracle in informatica?
Explain with an simple example
Answers were Sorted based on User's Feedback
Answer / vijay
Using Stored Porcedure Transformation we can call the
|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
|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
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|
why dimenstion tables are denormalized in nature ?
If the records doesnt satisfy the filter condition where will it go?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is the term PIPELINE in informatica ?
can u any challenge your project?
How can you recover the session in sequential batches?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
explain abt ur project architecture?
what is plsql table?
What happens if we dont select data driven option?
how will you remove the duplicate records from flat file without using sorter?
write a query for how to eliminate the duplicate rows without using distinct?