In ur current projectu have done any performance tuning of
mappings?
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
What are the modules in Power Center
Explain what transformation and how many are there in informatica?
can anyone suggest best free Talend data integration training online
What happens when a session fails and you click on recover?
What is target designer and target load order?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can a transformation be made reusable?
What is the use of code page?
In informatica workflow manager, how many repositories can be created?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the transformations that are not supported in mapplet?
How to generate sequence numbers?
What are the guidelines to be followed while using union transformation?
What is complex mapping?
What is a joiner transformation and why it is an active one?