How to improve the session performance in informatica?

Question Posted / chandranmca2007

3 Answers
21532 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to improve the session performance in informatica?..

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

How to improve the session performance in informatica?..

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

How to improve the session performance in informatica?..

Answer / sehaj

MR GYANA RANJAN BEHERA.....CAN U TELL ME WHEN WE ARE USIN
SESSION IN BULK MODE THEN WHAT IS THE NEED OF SETTIN D
BUFFER BLOCK SIZE ?

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Informatica Interview Questions

Can a joiner be used in a mapplet.

1 Answers

What do think which one is the better joiner or look up?

0 Answers

Explain incremental aggregation in informatica

0 Answers Informatica,

How can you access the remote source into your session?

1 Answers

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

5 Answers Wipro,

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers Wipro,

What are the types of data that passes between informatica server and stored procedure?

1 Answers Informatica,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers

What is the Difference between PowerPlay transformer and power play reports?

1 Answers

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

3 Answers Accenture,

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

9 Answers

How to update source definition?

0 Answers

For more Informatica Interview Questions Click Here