ICC Data Integration & Management 2 — Questions and Answers
Question 1: Which Informatica IICS component is responsible for executing mappings and tasks at runtime?
- Administrator
- Data Integration Server (Secure Agent) (Correct answer)
- Monitor
- Cloud Application Integration
Correct answer: Data Integration Server (Secure Agent)
The Secure Agent is the runtime engine that executes mappings, tasks, and workflows on-premises or in cloud environments.
Question 2: In IICS, what is the purpose of a Connection in a mapping?
- To define transformation logic between fields
- To specify the runtime environment for execution
- To provide credentials and endpoint details for a data source or target (Correct answer)
- To schedule when a task runs
Correct answer: To provide credentials and endpoint details for a data source or target
A Connection stores the credentials, host, port, and other configuration needed to connect to a source or target system.
Question 3: What does a Pushdown Optimization (PDO) setting of 'Full' do in an IICS mapping?
- Forces all transformations to run on the Secure Agent
- Pushes all supported transformation logic to the source or target database engine (Correct answer)
- Enables parallel processing across multiple Secure Agents
- Automatically tunes query performance using AI
Correct answer: Pushes all supported transformation logic to the source or target database engine
Full PDO instructs IICS to push as much transformation logic as possible down to the database, reducing data movement.
Question 4: Which transformation in IICS Data Integration is used to remove duplicate rows from a data set?
- Filter
- Sorter
- Duplicate Record Exception (Correct answer)
- Aggregator
Correct answer: Duplicate Record Exception
The Duplicate Record Exception transformation identifies and routes or removes duplicate records based on specified key fields.
Question 5: When configuring an IICS Taskflow, what is a Decision task used for?
- To pause execution until a manual approval is received
- To branch the flow based on a conditional expression evaluation (Correct answer)
- To retry a failed mapping task automatically
- To send an email notification when a step completes
Correct answer: To branch the flow based on a conditional expression evaluation
A Decision task evaluates a Boolean expression and routes execution to different branches depending on true or false outcome.
Question 6: In IICS, which file format is NOT natively supported as a flat file source in a mapping?
- CSV
- Fixed-width
- Parquet (Correct answer)
- COBOL copybook
Correct answer: Parquet
Parquet is a columnar storage format supported via connectors like ADLS or S3, not as a native flat file source type in flat file connections.
Question 7: What is the role of the 'Mapping Configuration Task' (MCT) in IICS?
- It generates a mapping automatically from a schema comparison
- It wraps a mapping so it can be scheduled and run with configurable parameters at runtime (Correct answer)
- It converts a mapping to a reusable sub-mapping
- It tests a mapping in debug mode without writing to the target
Correct answer: It wraps a mapping so it can be scheduled and run with configurable parameters at runtime
An MCT exposes a mapping as a runnable task with overridable parameters, making it schedulable and configurable for different runtime scenarios.
ICC Data Integration & Management 2
Which Informatica IICS component is responsible for executing mappings and tasks at runtime?