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
How are the sources and targets definitions imported in informatica designer?
Why union transformation is an active transformation?
What is dynamic cache?
server hot-ws270 is connect to Repository B. What does it mean?
What are the advantages of using informatica as an etl tool over teradata?
What is informatica worklet?
Explain dynamic target flat file name generation in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is substr in informatica?
how to load dimension table and fact table. plz tell me the steps.
Differentiate between reusable transformation and mapplet.
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the code page compatibility?
How can a transformation be made reusable?
What is a filter transformation and why it is an active one?