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 |
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
What are the new features of informatica 7.1?
COM components can be used in Informatica
What are the different types of code pages available in informatica & how to implement it in your project?
What is the difference between Normal load and Bulk load?
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?
What is xml source qualifier transformation in informatica?
what is flat file override?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What can we do to improve the performance of informatica aggregator transformation?
In operator is used in which transformation in informatica 8.6.0
In session log thier should not be a single error how will u do