How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Answer Posted / ratna
Performance tuning is a trail and error method. By using the session Log we would like to know where the bottle neck is. For each session DTM processor creates one reader, one transformation and one writer thread will create. In session log we can find Buzzy time. which is having the highest buzzy percentage that where the bottleneck present. We have to over come this by using the performance tuning Technics.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
Scheduling properties,whats the default (sequential)
What are the different ways to implement parallel processing in informatica?
What is meant by query override?
Explain scd type 3 through mapping.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the types of caches in lookup? Explain them.
what is SDLC way of code development?
What is a joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the performance considerations when working with aggregator transformation?
How many ways are there to do 'remove duplicate records in informatica'?
How do you load alternate records into different tables through mapping flow?
What is sq transformation?
How can we improve session performance in aggregator transformation?