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 is mean by complex business rule ?
Describe the impact of several join conditions and join order in a joiner transformation?
What is data movement mode in Informatica and difference between them?
Explain lookup transformation source types in informatica
What is a repository manager?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Quickly characterize reusable change?
What is the advantage of informatica?
What is informatica?
How to start a workflow using pmcmd command?
Differentiate between source qualifier and filter transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is a node in Informatica?
How to create or import flat file definition in to the warehouse designer?
Explain direct and indirect flat file loading (source file type) - informatica