Can I read Pushdown Optimization Mapping Guide on EtoBox?
Pushdown Optimization Mapping Guide by Dudi Kumar is a document available to read on EtoBox.
What is Pushdown Optimization Mapping Guide about?
This document describes a mapping solution that demonstrates implementing pushdown optimization in a mapping with a connected lookup transformation. The mapping contains an EMPLOYEES source table and EMPLOYEES_JOB_DESC target table in the same database. It inserts target records by populating the JOB_DESC column using a connected lookup on the JOBS table. When run with pushdown optimization, the mapping executes as a single SQL query on the database to process the transformations.
- Author
- Dudi Kumar
- Language
- EN