ICC Performance Monitoring & Troubleshooting 3 — Questions and Answers
Question 1: What does the 'rows affected' metric in an IICS session log indicate when it shows a significantly lower count than 'rows read'?
- Rows were filtered by a Filter transformation or rejected by target constraints (Correct answer)
- The source returned duplicate rows
- The session ran in preview mode
- The target database had row-level locking
Correct answer: Rows were filtered by a Filter transformation or rejected by target constraints
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?
- Threshold-based alerting
- Anomaly detection using machine learning (Correct answer)
- SLA-based monitoring rules
- Session log comparison
Correct answer: Anomaly detection using machine learning
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?
- Sort both input streams before the Joiner and enable sorted input (Correct answer)
- Increase DTM buffer memory for the Joiner cache
- Add a Router transformation to split records before joining
- Use a Union transformation instead of the Joiner
Correct answer: Sort both input streams before the Joiner and enable sorted input
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?
- Initializing
- Queued (Correct answer)
- Waiting
- Pending
Correct answer: Queued
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?
- Use a persistent cache stored on disk (Correct answer)
- Disable caching and query the lookup source for every row
- Increase the cache directory allocation
- Use dynamic cache to only cache matched rows
Correct answer: Use a persistent cache stored on disk
Persistent cache stores lookup data on disk across sessions, reducing RAM consumption while avoiding repeated source queries.
Question 6: In IICS, where would you find the error message for a task that failed during the 'Pre-SQL' execution phase?
- The target error file
- The session log (Correct answer)
- The Monitor activity summary
- The connection test log
Correct answer: The session log
Pre-SQL and Post-SQL errors are captured in the session log with specific SQL statements and database error codes.
Question 7: Which Informatica Cloud feature allows teams to track performance trends of a specific mapping over time using historical run data?
- Job comparison view in Monitor
- Operational Insights job timeline (Correct answer)
- Activity Log export to CSV
- Audit trail reports
Correct answer: Operational Insights job timeline
Operational Insights provides historical performance timelines for individual jobs, enabling trend analysis and regression detection.
ICC Performance Monitoring & Troubleshooting 3
What does the 'rows affected' metric in an IICS session log indicate when it shows a significantly lower count than 'rows read'?