ICC Performance Optimization 5

Question 1

What is the purpose of the 'Optimizer Level' setting in an IICS mapping session properties?

Accepted Answer

It enables automatic optimizations such as early selection, push-into, and cost-based reordering of transformations

Answer

The Optimizer Level instructs IICS how aggressively to apply automatic rewrite rules—higher levels enable more transformations like pushdown and cost-based reordering.

Question 2

An IICS synchronization task is performing poorly because it recalculates derived fields for every source row even when the source data is unchanged. Which technique addresses this?

Accepted Answer

Using CDC (Change Data Capture) to process only modified rows

Answer

CDC identifies only rows that changed since the last run so unchanged rows never enter the mapping, eliminating wasted computation.

Question 3

Which IICS Secure Agent JVM tuning parameter should you increase when a mapping that processes large XML or JSON payloads throws 'OutOfMemoryError'?

Accepted Answer

-Xmx (maximum heap size)

Answer

-Xmx sets the JVM's maximum heap, providing more memory for parsing and holding large in-flight XML/JSON documents.

Question 4

When designing an IICS pipeline to load a 500 GB file from Amazon S3 into Redshift, which approach yields the fastest load time?

Accepted Answer

Splitting the file into multiple smaller files and using Redshift COPY with parallel manifest loading

Answer

Redshift COPY with a manifest file over multiple S3 objects parallelizes across all compute nodes, saturating I/O bandwidth and minimizing load time.

Question 5

In IICS, what does enabling 'constraint-based loading' on a target allow the Secure Agent to do?

Accepted Answer

Enforce referential integrity by loading parent tables before child tables automatically

Answer

Constraint-based loading ensures parent records exist before child records are inserted, preventing foreign-key violations without manual ordering.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Performance Optimization 5