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...

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


Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2150


Scheduling properties,whats the default (sequential)

2007


What are the different ways to implement parallel processing in informatica?

1471


What is meant by query override?

1112


Explain scd type 3 through mapping.

1050


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7586


What are the types of caches in lookup? Explain them.

1009


what is SDLC way of code development?

2089


What is a joiner transformation?

1033


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2573


What are the performance considerations when working with aggregator transformation?

1198


How many ways are there to do 'remove duplicate records in informatica'?

1061


How do you load alternate records into different tables through mapping flow?

1924


What is sq transformation?

1226


How can we improve session performance in aggregator transformation?

1149