Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7804 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhava
To increase the running performance on mapping level.
Techniques of mapping optimization has follow:
1). If its having Filter TX on your mapping place it on
close to the SourceQualifier TX.
2). If in case you are having two or more same DB sources,
use the SQL Override and join it(Instead of Joiner).
3). Use the cache on lookup, Joiner, Aggregator TX. ; etc..
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What does reusable transformation mean?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How might one distinguish in the case of mapping is right or not without associating session?
define galaxy repository in informatica
What is informatica metadata and where is it stored?
What is domain in terms of informatica?
Which development components of informatica have the highest usage?
Different sorts of metadata that stores in the storage facility?
What is mapping debugger?
How to generate sequence numbers using expression transformation?
design of staging area?
Explain in detail scd type 2 through mapping.
What is the fact table?
Explain sessions and how many types of sessions are there?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
