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?
- 4 Answers
- 35637 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan
Run ur session in Verbose Mode and check out the Busy
Percentage in the Log. IF its more at the Reader thread
than ur Source Query is the Bottleneck.Tune your SQ.
If its Writer thread, then you check with your target . May
be you need to drop and recreate the Indexes on the target
table.
If its the Transformation thread , then check with your
mapping logic. Concentrate More on Aggregator part..
Fine tune your logic. Don't drag the fields which are not
used to all the transformations. try to use as less
transformations as possible.
Cache your lookups .Whenever possible use the persistent
lookup concept.
This should help guys..
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
Is it possible to revert a global repository to local one and why?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain incremental aggregation in informatica
What is a surrogate key?
What are the restrictions of union transformation?
How do you load only null records into target?
what is Active lock explain
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is meant by query override?
What is the Process to creating lookup transformation in informatica
Enlist the advantages of informatica.
what is SDLC way of code development?
What you know about transaction control transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
