Performance Monitoring & Troubleshooting Flashcards

A Synchronization task in IICS is running slowly against a Salesforce source. Which technique BEST improves throughput for this scenario?

Answer: Enable bulk API mode in the Salesforce connection

Salesforce Bulk API processes data in large batches asynchronously, providing significantly higher throughput than the standard REST API.

When troubleshooting a failed IICS mapping, the session log shows 'ORA-00001: unique constraint violated'. What is the correct remediation in the target connection settings?

Answer: Enable the 'Insert else Update' write strategy

The 'Insert else Update' (upsert) strategy prevents duplicate key violations by updating existing records instead of inserting duplicates.

Which IICS Secure Agent configuration parameter controls the maximum number of concurrent mapping sessions that can run on a single agent?

Answer: DTM.MaxProcesses

DTM.MaxProcesses in the Secure Agent's agent properties controls how many simultaneous DTM processes can run on that agent.

In IICS, a mapping fails with 'DTM_15007 Transformation evaluation error'. Which troubleshooting action is MOST appropriate?

Answer: Enable Verbose Data logging and re-run to identify the offending row

DTM_15007 indicates a runtime data error in a transformation; Verbose Data logging reveals the exact row and field causing the failure.

Which health check should be performed when a Secure Agent shows as 'Disconnected' in the IICS Administrator console?

Answer: Verify the agent host can reach cdn.informaticacloud.com on port 443

The Secure Agent requires outbound HTTPS access to Informatica Cloud endpoints; blocked port 443 is the most common cause of disconnection.

What is the purpose of the 'High Availability' configuration in an IICS Runtime Environment with multiple Secure Agents?

Answer: To distribute load and allow jobs to failover to another agent if one becomes unavailable

A multi-agent Runtime Environment provides load distribution and automatic failover, so jobs continue running if one Secure Agent goes down.

An IICS incremental load mapping is picking up far more records than expected on each run. Which configuration should be reviewed first?

Answer: The high watermark timestamp column and its update logic

If the high watermark is not being updated correctly after each run, subsequent runs will reprocess records from previous cycles.