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 would you join a node to the already existing domain?
What is the need of an ETL tool?
expain about the tune parameters?
Tell me about Propagate functions in informatica
What is a dimensional model?
What is the use of code page?
have u done any performance tuning? how u ll do?
What is lookup change?
What are the new features of informatica 9.x developer?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the new features of informatica 9.x at the developer level?
How to join three sources using joiner? Explain though mapping flow.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Make a note of the quantity vaults made in informatica?