Interested to Buy Any Domain ? << Click Here >> for more details...
In ur current projectu have done any performance tuning of
mappings?
- 1 Answers
- 4534 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
Explain pushdown optimization and types in informatica
What is a rank transform?
What are the types of presistent cache in look up tr.
Performance tuning in UNIX for informatica mappings?
As union transformation gives UNION ALL output, how you will get the UNION output?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the meaning of decode in informatica?
What is DR strategy for Informatica project?
How can you validate all mappings in the repository simultaneously?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a repository? And how to add it in an informatica client?
Which transformation should we use to normalise the COBOL and relational sources?
How can we use mapping variables in informatica? Where do we use them?
What happens when a session fails and you click on recover?
