ICC Performance Optimization 2

Question 1

Which Informatica IICS feature allows you to run multiple mapping tasks concurrently within a single taskflow?

Accepted Answer

Parallel task execution using Concurrent Tasks

Answer

Concurrent Tasks in a taskflow allow multiple mapping tasks to execute in parallel, reducing overall pipeline wall-clock time.

Question 2

When optimizing a mapping that reads from a large Salesforce object, which technique most reduces API call volume?

Accepted Answer

Using incremental extraction with a last-modified date filter

Answer

Incremental extraction filters records by a timestamp field so only changed data is pulled, dramatically cutting API calls on repeat runs.

Question 3

In IICS Data Integration, what does increasing the 'DTM buffer size' parameter primarily affect?

Accepted Answer

The amount of memory allocated for data transformation in-memory processing

Answer

DTM buffer size controls how much RAM is reserved for row processing; a larger buffer reduces disk spill and improves throughput.

Question 4

Which Source qualifier option in a mapping helps avoid a full-table scan on a relational source when only a subset of rows is needed?

Accepted Answer

Use a SQL override with a WHERE clause

Answer

A SQL override with a WHERE clause pushes the filter predicate to the database, returning only matching rows and eliminating a full scan.

Question 5

What is the recommended approach when a Joiner transformation in IICS causes performance degradation due to a very large master pipeline?

Accepted Answer

Cache the smaller dataset and use it as the master input

Answer

Caching the smaller dataset as the master minimizes repeated comparison passes and greatly speeds up the join operation.

(ICC) Informatica Cloud Certification Practice Test