Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to improve the session performance in informatica?

Question Posted / chandranmca2007

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

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

What are the new features of informatica 7.1?

2 Answers  

COM components can be used in Informatica

0 Answers  

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

What is the difference between Normal load and Bulk load?

5 Answers  

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

What is xml source qualifier transformation in informatica?

0 Answers  

what is flat file override?

1 Answers   Cap Gemini, HP,

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

In session log thier should not be a single error how will u do

3 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories