Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the session performance in informatica?
- 3 Answers
- 21323 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
Which development components of informatica have the highest usage?
Explain Dataware house architecture .how data flow from intial to end?
What is update strategy transform?
Define enterprise data warehousing?
What is a grid in Informatica?
What is event and what are the tasks related to it?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is dimensional table?
What is meant by target load plan?
what is SDLC way of code development?
have u done any performance tuning? how u ll do?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is a stored procedure transformation?
Explain how to import oracle sequence into informatica?
Why update strategy and union transformations are active? Explain with examples.
