Multiple choice technology databases Default caching mechanism for lookup transformation. static persistent dynamic shared Reveal answer Fill a bubble to check yourself C Correct answer Explanation The default caching mechanism for lookup transformation is dynamic caching. This means the cache is built as needed during transformation execution rather than being static or persistent across multiple runs.