Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7707 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 is fact table? Explain the different kinds of facts.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How might one distinguish in the case of mapping is right or not without associating session?
What is meant by target load plan?
How union transformation is used?
Design a mapping to load a target table with the following values from the above source?
can we override a native sql query within informatica? Where do we do it?
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
Explain how to import oracle sequence into informatica?
How we can use union transformation?
difference between informatica 8.1.1 and 8.6
What is aggregate cache in aggregator transformation?
Differences between connected and unconnected lookup?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is informatica?
