Interview Questions

How to fine tune mappings? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

11. How to fine tune mappings? - ETL

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

(Continued on next question...)

Other Interview Questions