|
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
| 