Tasks

Back Next

SQL ELT optimization in advanced mode

You can run a mapping in advanced mode using full SQL ELT optimization to push all transformation logic to the source and target databases.

If full SQL ELT optimization isn't possible,

Data Integration

runs the mapping logic on the Data Integration Server and on an

advanced cluster

The following table describes the log files that you can use to troubleshoot the job:

Log file	Description
Session log	Indicates whether SQL ELT optimization is possible.
Mapping compilation log	Displays the SQL query that runs on the database.
Spark driver log	Displays the SQL query that runs on the database and the individual entries that track job progress on the database.