ICC Performance Monitoring & Troubleshooting 3

Question 1

What does the 'rows affected' metric in an IICS session log indicate when it shows a significantly lower count than 'rows read'?

Accepted Answer

Rows were filtered by a Filter transformation or rejected by target constraints

Answer

A lower 'rows affected' count compared to 'rows read' typically means rows were dropped by a Filter transformation or rejected at the target.

Question 2

Which Informatica Cloud Operational Insights capability can automatically detect when a job's duration is statistically anomalous compared to its historical baseline?

Accepted Answer

Anomaly detection using machine learning

Answer

Operational Insights uses ML-based anomaly detection to flag jobs that deviate from their learned historical performance patterns.

Question 3

An IICS mapping using a Joiner transformation is slow. What is the MOST effective tuning option for this scenario?

Accepted Answer

Sort both input streams before the Joiner and enable sorted input

Answer

Pre-sorting both input pipelines and enabling sorted input on the Joiner eliminates the need for in-memory sorting, greatly improving performance.

Question 4

Which status in IICS Monitor indicates that a job has been submitted but is waiting for an available Secure Agent thread to begin processing?

Accepted Answer

Queued

Answer

A 'Queued' status means the job is submitted and waiting in the execution queue for an available resource on the Secure Agent.

Question 5

A mapping with Lookup transformations consumes excessive memory. Which caching strategy reduces memory footprint while maintaining lookup accuracy?

Accepted Answer

Use a persistent cache stored on disk

Answer

Persistent cache stores lookup data on disk across sessions, reducing RAM consumption while avoiding repeated source queries.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Performance Monitoring & Troubleshooting 3