In ur current projectu have done any performance tuning of
mappings?



In ur current projectu have done any performance tuning of mappings?..

Answer / 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

More Informatica Interview Questions

What are the basic needs to join two sources in a source qualifier?

3 Answers  


After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  


can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,


Can we update the data in flat file using update strategy?

3 Answers  


I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,






what is the size of u r source(like file or table)?

0 Answers   HP,


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  


How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,


Categories