Interested to Buy Any Domain ? << Click Here >> for more details...
In ur current projectu have done any performance tuning of
mappings?
- 1 Answers
- 4724 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreedhar lokaray
Many people are not sure how exactly to tune the
performance of a mapping. There is no thumb rule for
performance tuning. A tuning done in one mapping cannot be
applied into another mapping. But still below given are
some of the performance tuning tips.
Joiner instead of Lookup: If the lookup table has large no.
of records then the performance will affect because it has
to build the cache. Instead use a joiner transformation and
check it as detail rows. This will avoid building cache.
Sorted Input: Use sorter transformation before joiner or
aggregator. This will improve the performance.
Source Qualifier: Try to filter out unwanted records in the
source qualifier before moving to the next transformation.
Also delete unconnected/unused ports.
Indexes: Try to have proper indexes on the required fields
of the tables in the database which will increase the
performance. At the same time having indexes on the target
will kill the performance when you try to insert huge
volumes of data. To avoid this, disable the indexes on the
target (using sql loader direct load process) and then load
the data. After loading enable the index back.
Keep in mind that tuning performance of one transformation
can kill the performance of other transformation. We have
to maintain the equilibrium.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How do we call shell scripts from informatica?
What is target load order?
What is meant by incremental aggregation?
What is incremental aggregation?
What are connected or unconnected transformations?
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 the difference between informatics 7x and 8x and what is latest version?
How to extract the informatica rejected data?
What is a filter transformation?
what is $$$$?
What is the use of an aggregator cache file?
Which version configuration tool used in ur project?
draw informatica architecture 8.6 ?
Briefly define a session task?
