How to improve the session performance in informatica?
- 3 Answers
- 20786 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
What is an aggregator transformation?
What is workflow? What are the components of workflow manager?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What happens when a session fails and you click on recover?
Is it possible to create multiple domains on a single Informatica server?
What are the different options available for update strategy?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is native users?
What is fact table? Explain the different kinds of facts.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
how we can load rejected record's at run time?(not through bad files)
list out all the transformations which use cache?
How to Create a folder using pmrep command?
What are the tasks that source qualifier perform?
