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 to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?

Answer Posted / srinu

identification of bottelnecks
target:configuring session to write to flatfiletarget
source:add filter t/r after sq t/t to false show that no
data is processed past the filter t/r,if it time takes to
run new session remains same to the original session there
is source bottel necks
mapping:add filter t/f before each target and set filter
condition to false,similar to source
session:use the collect performance data to identify the
session bottel necks
read from desk,write to disk counters other than zero,there
is bottelnecks

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

 Informatica Checkpoints

3332


Briefly explain the aggregator transformation?

1010


Explain sessions?

1066


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1069


Why update strategy and union transformations are active?

1043


what is the -ve test case in your project.

2407


What is session task and command task?

1298


What is a repository? And how to add it in an informatica client?

1149


What is complex mapping?

1122


How can we delete duplicate rows from flat files?

1223


What is option by which we can run all the sessions in a batch simultaneously?

1144


What is the use of target designer?

1055


can we override a native sql query within informatica? Where do we do it? How do we do it?

1055


can you please explain me pre session and post session options?

7570


What are data-driven sessions?

1213