Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ram


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

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

What is the difference between view and materialised view?

6 Answers  

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

how can we use sorter transformation in joins?

5 Answers   IBM,

Can you create a flatfile target

3 Answers   ABC,

What is workflow monitor?

0 Answers  

Why we use partitioning the session in informatica?

2 Answers  

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

What is confirmed dimension and fact?

7 Answers  

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories