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



How did you handle performance issues If you have data coming in from multiple sources, just walk th..

Answer / 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

More Informatica Interview Questions

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


How do you create single lookup transformation using multiple tables?

6 Answers   TCS,


How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  






What is the Difference between DSS & OLTP?

5 Answers  


What is decode in informatica?

0 Answers  


why we use informatica in our project?

2 Answers   TCS,


What is synonym?

2 Answers   Patni,


What are the new features in Informatica 5.0?

1 Answers  


how can we calculate fact table size?

1 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


Categories