Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the session performance in informatica?
- 3 Answers
- 21642 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 is a pre-defined event and user-defined event?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What is data transformation manager process?
How to use Normalizer transformation?
Can we create out put ports in source qualifier t/r?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is the predefined port in dynamic lookup
How can one identify whether mapping is correct or not without connecting session?
Name 4 output files that informatica server creates during session running?
Teradata 
