Tuesday, March 19, 2013
How do you configure mapping in informatica?
You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary links between transformations. For transformations that use data cache (such as Aggregator Joiner Rank and Lookup transformations) limit connected input/output or output ports. Limiting the number of connected input/output or output ports reduces the amount of data
the transformations store in the data cache.
You can also perform the following tasks to optimize the mapping:
1. Configure single-pass reading.
2. Optimize datatype conversions.
3. Eliminate transformation errors.
4. Optimize transformations.
5. Optimize expressions.