Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which transformation should we use to normalise the COBOL and relational sources?
Briefly explain the aggregator transformation?
Explain joiner transformation in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
How does a sorter cache works?
Explain sessions?
Differentiate between router and filter transformation?
Target increases every day even though no new record was inserted
How to join three sources using joiner? Explain though mapping flow.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Define the various join types of joiner transformation?
What is expression transformation?
What is the surrogate key?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the uses of etl tools?
