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
- 35490 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
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?
How many number of sessions can one group in batches?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to convert multiple rows to single row (multiple columns) in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Scheduling properties,whats the default (sequential)
What is a passive transformation?
How to update source definition?
Differentiate between a repository server and a powerhouse?
How to start a workflow using pmcmd command?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a shortcut and copy in Informatica and how two are different with each other?
How do you load unique records into one target table and duplicate records into a different target table?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
