IICS Certification Data Integration in IICS 2 — Questions and Answers
Question 1: Which IICS transformation splits incoming rows into multiple output groups based on conditions?
- Sorter
- Router (Correct answer)
- Normalizer
- Lookup
Correct answer: Router
The Router transformation evaluates conditions and routes each row to one of multiple output groups.
Question 2: In IICS Data Integration, what is a 'Mapping Task'?
- A reusable transformation object
- A runnable instance of a mapping with a specific runtime configuration (Correct answer)
- A schedule for recurring jobs
- A target schema definition
Correct answer: A runnable instance of a mapping with a specific runtime configuration
A Mapping Task is a runnable object that pairs a mapping with a specific Secure Agent and runtime settings.
Question 3: What is the 'Lookup' transformation in IICS used for?
- Sorting data by a key column
- Looking up related data from a source or cache to enrich the data stream (Correct answer)
- Aggregating numeric columns
- Splitting data into multiple pipelines
Correct answer: Looking up related data from a source or cache to enrich the data stream
The Lookup transformation queries a lookup source or cache to retrieve related data and enrich the pipeline rows.
Question 4: Which IICS feature allows you to parameterize mapping inputs so the same mapping runs against different sources?
- Dynamic Mappings
- Mapping Parameters (Correct answer)
- Advanced Mode
- Auto-mapping
Correct answer: Mapping Parameters
Mapping Parameters allow you to define variable inputs such as connection names, source tables, and filter values that can differ at runtime.
Question 5: What transformation would you use in IICS to combine rows from two related streams using a common key?
- Union
- Joiner (Correct answer)
- Expression
- Normalizer
Correct answer: Joiner
The Joiner transformation merges rows from two input pipelines based on a matching key column, similar to a SQL join.
Question 6: In IICS Data Integration, what does 'pushdown optimization' do?
- Pushes transformation logic into the database engine to improve performance (Correct answer)
- Compresses data before writing to target
- Splits large files into partitions
- Caches lookup data in memory
Correct answer: Pushes transformation logic into the database engine to improve performance
Pushdown optimization translates mapping logic into native SQL and executes it directly on the database, reducing data movement.
IICS Certification Data Integration in IICS 2
Which IICS transformation splits incoming rows into multiple output groups based on conditions?