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 |
What is a snowflake schema?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
How do you load first and last records into target table?
Why use the lookup transformation ?
How to update or delete the rows in a target, which do not have key fields?
What is the Difference between SetVariable and setmaxvariable in informatica?
How many types of sessions are there in informatica.please explain them?
How to generate sequence numbers without using the sequence generator transformation?
how to insert header after each group.