A runtime strategy determines whether the mapping task runs on an advanced cluster or using SQL ELT optimization. Runtime strategies are powered by CLAIRE, Informatica's AI engine. CLAIRE uses FinOps capabilities to identify the runtime strategy that saves the most on cloud infrastructure costs and optimizes job performance.
If CLAIRE recommendations are enabled in your organization, you can select a runtime strategy when you create a mapping task based on a mapping in advanced mode. CLAIRE analyzes the mapping and recommends one of the following runtime strategies to optimize cost, performance, or both:
•Advanced cluster. Schedules the workload for distributed processing on an advanced cluster.
•SQL ELT optimization. Converts the transformation logic to an SQL query and sends the query to the data warehouse.
The following image shows a recommendation that you might see:
The default runtime strategy runs the mapping task on an advanced cluster or using SQL ELT optimization based on whether SQL ELT optimization is configured on the Runtime Options page. If SQL ELT optimization is configured, the mapping task runs using SQL ELT optimization. Otherwise, the mapping task runs on an advanced cluster.
The target duration confidence level shows the likelihood that the job will run within the target duration that you specify. The confidence level can change based on the runtime strategy that you select. If you select the runtime strategy that is more performant, it's more likely that the mapping task will run within its target duration.
Note: Runtime strategy recommendations and the target duration confidence level might not appear for some mapping tasks. CLAIRE continues collecting metadata in the background and shows these details when it has enough confidence.
Runtime strategies aren't available for mapping tasks that run in a serverless runtime environment.
