ICC Performance Monitoring & Troubleshooting 2 — Questions and Answers
Question 1: In Informatica Cloud, which session log detail level provides the most granular information for troubleshooting data transformation errors?
- Normal
- Verbose Initialization
- Verbose Data (Correct answer)
- Terse
Correct answer: Verbose Data
Verbose Data level logs every row of data processed, offering the most detail for diagnosing transformation errors.
Question 2: A mapping in IICS consistently runs out of memory. Which configuration change is MOST likely to resolve this?
- Increase the number of partitions
- Enable pushdown optimization (Correct answer)
- Reduce the default buffer block size
- Switch from DTM buffer memory to operating system memory
Correct answer: Enable pushdown optimization
Enabling pushdown optimization offloads processing to the source or target database, reducing DTM memory consumption.
Question 3: Which Informatica Cloud monitor view shows real-time CPU and memory utilization for a running job on the Secure Agent machine?
- Activity Log
- Session Statistics
- Runtime Environment Monitor
- Job Monitor (Correct answer)
Correct answer: Job Monitor
The Job Monitor in Monitor provides real-time visibility into the status and resource usage of running jobs.
Question 4: When a Secure Agent reports 'connection timeout' errors intermittently, which troubleshooting step should be performed FIRST?
- Restart the Secure Agent service
- Check network firewall rules between the agent and the target (Correct answer)
- Increase the connection pool size in the connection properties
- Upgrade the Secure Agent to the latest version
Correct answer: Check network firewall rules between the agent and the target
Intermittent connection timeouts most commonly indicate network or firewall issues rather than agent or pool configuration problems.
Question 5: Which IICS feature allows you to set a threshold and receive an alert when a mapping job exceeds a specified runtime duration?
- Operational Insights anomaly detection
- Job Monitor schedule alerts
- Monitoring alert rules (Correct answer)
- Activity log filters
Correct answer: Monitoring alert rules
Monitoring alert rules in IICS let administrators define thresholds and notify stakeholders when jobs exceed runtime limits.
Question 6: A mapping that reads from a flat file runs significantly slower than expected. Which transformation optimization should be evaluated FIRST?
- Add a Sorter transformation before the target
- Enable concurrent read partitioning on the Source transformation (Correct answer)
- Add a Lookup transformation to cache reference data
- Enable data compression on the source file
Correct answer: Enable concurrent read partitioning on the Source transformation
Concurrent read partitioning splits the file read across multiple threads, directly improving flat file source throughput.
Question 7: In IICS, which log file on the Secure Agent host machine captures service startup errors that are not visible in the cloud Monitor UI?
- tomcat/logs/catalina.out
- infaagent/logs/agent.log (Correct answer)
- logs/sessionlog.log
- pmserver.log
Correct answer: infaagent/logs/agent.log
The agent.log file in the infaagent/logs directory captures Secure Agent startup, service registration, and connectivity errors.
ICC Performance Monitoring & Troubleshooting 2
In Informatica Cloud, which session log detail level provides the most granular information for troubleshooting data transformation errors?