How to improve the session performance in informatica?
- 3 Answers
- 20050 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
What are the different caches used in informatica?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define sessions in informatica etl?
what is the monster dimension plz give me one example
what is filelist concept in informatica
What aer the out put files that the informatica server creates during the session running?
what is distinct
Label in Informatica. How to remove existing Label.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
what is semi-additive fact?where did u used?
Teradata 
