Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the session performance in informatica?
- 3 Answers
- 21647 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
How we can create indexes after completing the load process?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to join three sources using joiner? Explain though mapping flow.
What is the commit type if you have a transaction control transformation in the mapping?
What are ETL Tools?
is it possible to index the data in cache of lkp transformation ?
How can repository reports be accessed without sql or other transformations?
Which version configuration tool used in ur project?
What is option by which we can run all the sessions in a batch simultaneously?
What is the cumulative sum and moving sum?
What is a shortcut and copy in Informatica and how two are different with each other?
Can anyone tell me the new features in Informatica 9 Version?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
