how we do performence tuning in informatica
- 3 Answers
- 6844 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
First we need to identify the bottlenecks,
Then we need to do peer review
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / karthik
Guys we know the bottle necks, but pls tel us how do we
resolve it..
for example :
if source is reading the date very slowly, how do we solve
that??
| Is This Answer Correct ? | 0 Yes | 0 No |
What is informatica? Why do we need it?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
wht is full process of Information source to target just like stg to productuon and development
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is option by which we can run all the sessions in a batch simultaneously?
What are the new features of informatica 7.1?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
how do u tune queries?
What are the data movement modes in informatica?
What are the challenges of Dataware housing in the future?
scenario
Teradata 
