Configuring SQL ELT optimization for an SAP HANA mapping task
Perform the following steps to configure SQL ELT optimization for an SAP HANA mapping task:
1Create an SAP HANA connection.
2Create a mapping to read data from an SAP HANA source and write data to an SAP HANA target.
3Create a mapping task.
- aSelect the configured mapping.
- bIn the Runtime Options page, in the SQL ELT optimization section, set the SQL ELT optimization value to Full or Source.
- cSave the task and click Finish.
When you run the mapping task, the transformation logic is pushed to the SAP HANA database.