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
Post your comment