How to improve the session performance in informatica?
Answers were Sorted based on User's Feedback
Answer / gyana ranjan behera
SESSION LEVEL PERFORMANCE TUNING
(1)SET YOUR SESSION TO RUN IN BULK MODE
(2)DO SESSION PARTITION
(3)INCREASE COMMIT INTERVALS
(4)CHECK THE INCREMENTAL AGGREGATION
(5)DTM BUFFER SIZE MUST BE IN BETWEEN 6MB TO 128MB
(6)BUFFER BLOCK SIZE 4KB TO 128KB
| Is This Answer Correct ? | 24 Yes | 1 No |
Answer / vinay kumar
set properties of mapping tab set bulk loading option in sesstion then performs is increasng..........but sometimes session is failed, the session is no reusable
tht is an drawback
| Is This Answer Correct ? | 5 Yes | 0 No |
Can a joiner be used in a mapplet.
What do think which one is the better joiner or look up?
Explain incremental aggregation in informatica
How can you access the remote source into your session?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What is the exact difference b/w IN and EXIST in Oracle..?
What are the types of data that passes between informatica server and stored procedure?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What is the Difference between PowerPlay transformer and power play reports?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
How to update source definition?