ICC Performance Optimization 3

Question 1

Which Informatica IICS Advanced Cluster configuration option helps reduce data shuffling costs when performing large aggregations on cloud data?

Accepted Answer

Enabling partitioning by the aggregation key

Answer

Partitioning the data by the aggregation key ensures all rows for a group land on the same node, eliminating cross-node data shuffles.

Question 2

What effect does enabling 'high precision' on a numeric port in an IICS mapping have on performance?

Accepted Answer

It can slow performance because it uses Informatica's internal high-precision decimal engine

Answer

High precision uses a software decimal library rather than native hardware floating-point, adding CPU overhead and reducing throughput.

Question 3

When should you use a 'Sorter' transformation placed before an 'Aggregator' in an IICS mapping?

Accepted Answer

When the Aggregator is not configured to use sorted input, and the source data is unsorted

Answer

A Sorter before the Aggregator enables 'sorted input' mode, which lets the Aggregator process groups sequentially without building a full in-memory cache.

Question 4

In an IICS Mass Ingestion task loading data to a data lake, which setting most directly controls how many files are processed in parallel?

Accepted Answer

Maximum concurrent connections / parallelism degree

Answer

The parallelism / maximum concurrent connections setting governs how many file transfer threads run simultaneously, directly impacting ingestion throughput.

Question 5

Which IICS transformation should be avoided in the critical path of a high-volume mapping because it blocks the pipeline until all input rows are received?

Accepted Answer

Aggregator transformation (without sorted input)

Answer

The Aggregator must collect all rows for a group before it can emit results, creating a blocking point that halts downstream processing.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Performance Optimization 3