IICS Certification IICS Certification 3 — Questions and Answers
Question 1: In IICS, which transformation is best suited to split a single input stream into multiple output groups based on filter conditions?
- Router (Correct answer)
- Filter
- Expression
- Union
Correct answer: Router
The Router transformation evaluates each row against multiple conditions and routes rows to different output groups, similar to a CASE statement.
Question 2: What is a 'Secure Agent Group' in IICS and when would you use multiple agents in a group?
- A cluster of agents that share workload for high availability and scalability (Correct answer)
- A set of agents restricted to a specific security zone
- A group of agents assigned to a single organization
- An encrypted agent configuration shared across runtimes
Correct answer: A cluster of agents that share workload for high availability and scalability
A Secure Agent Group pools multiple Secure Agents to distribute job load, providing fault tolerance and horizontal scalability for high-volume environments.
Question 3: In IICS Mass Ingestion, which ingestion type is used to continuously replicate database changes using log-based CDC?
- Database Ingestion and Replication (Correct answer)
- File Ingestion
- Streaming Ingestion
- Application Ingestion
Correct answer: Database Ingestion and Replication
Database Ingestion and Replication in IICS Mass Ingestion uses log-based change data capture (CDC) to continuously replicate changes from source databases.
Question 4: Which IICS Data Integration feature enables you to parameterize connection names, file paths, and filter conditions at runtime?
- Mapping Parameters (Correct answer)
- Runtime Attributes
- Input Fields
- Advanced Properties
Correct answer: Mapping Parameters
Mapping Parameters in IICS allow you to define placeholders for values like connection names and filter conditions that are resolved at task or job execution time.
Question 5: What is the purpose of the 'Error Rows' output group in the IICS Data Integration target transformation?
- Capture rows that fail to load into the target for separate handling (Correct answer)
- Store rows that triggered transformation errors
- Log duplicate rows rejected by a primary key constraint
- Redirect rows that failed expression evaluation
Correct answer: Capture rows that fail to load into the target for separate handling
The Error Rows output allows the mapping to route rows that fail target loading (e.g., constraint violations) to an alternate target or file for error handling.
Question 6: In IICS API Center (API Management), what is the role of a 'Managed API'?
- A published API endpoint secured and governed by API Center policies (Correct answer)
- An internal API only accessible within the IICS organization
- An API automatically generated from a Data Integration mapping
- A connector API managed by Informatica Support
Correct answer: A published API endpoint secured and governed by API Center policies
A Managed API in IICS API Center is an API endpoint that is published, secured with policies (throttling, authentication), and monitored through the API gateway.
Question 7: Which IICS transformation is used to look up values in a relational table or flat file to enrich pipeline data?
- Lookup (Correct answer)
- Joiner
- Expression
- Aggregator
Correct answer: Lookup
The Lookup transformation queries a lookup source (table or file) to retrieve matching values, commonly used to get surrogate keys or reference data.
IICS Certification IICS Certification 3
In IICS, which transformation is best suited to split a single input stream into multiple output groups based on filter conditions?