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 we do performence tuning in informatica

Answer Posted / srinu

Perf Tune is not an simple Question !!!!
its a process !!!

Performance of Informatica is dependant on the performance
of its several components like database, network,
transformations, mappings, sessions etc. To tune the
performance of Informatica, we have to identify the
bottleneck first. Bottleneck may be present in source,
target, transformations, mapping, session, database or
network.
Identify bottleneck in Source
Identify bottleneck in Target
Identify bottleneck in Transformation
Identify bottleneck in sessions
DATABASE OPTIMISATION
OPTIMUM CACHE SIZE IN LOOKUPS


so and so,,,,,,,,,,,,,,,,

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about Propagate functions in informatica

911


How can we update a record in the target table without using update strategy?

1121


Global and Local shortcuts. Advantages.

2017


What are the different components of powercenter?

1031


How do you load first and last records into target table?

1141


Enlist the various types of transformations.

1020


What are Dimensional table?

1044


What is the need of an ETL tool?

1070


What is meant by lookup transformation?

1084


If informatica has its scheduler why using third party scheduler?

1245


Enlist the tasks for which source qualifier transformation is used.

1022


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2333


what are the deliverables?in your project?

2129


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2112


How will the document be delivered to me?

1061