How to fine tune mappings? - ETL
How to fine tune mappings?
The following are the steps to fine tune mappings:
- Use the condition for filter in source qualifies without using filter
- Utilize persistence and cache that is shared in look up t/r
- Use the aggregations t/r in sorted i/p group by different ports
- Use operators in expressions instead of functions
- Increase the cache size and commit interval