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|
how we load the data from source to staging area
While importing the relational source defintion from database,what are the meta data of source U import?
Explain the difference between mapping parameter and mapping variable?
Can you copy the batches?
which one is better either active or passive transformation in informatica
How to generate a single mapping for both the historical and incremental load.
What is the exact difference b/w IN and EXIST in Oracle..?
What is hash partition?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?