Data Integration in IICS Flashcards
6 cards from real IICS Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Data Integration in IICS flashcards as text
Which IICS transformation splits incoming rows into multiple output groups based on conditions?
Answer: Router
The Router transformation evaluates conditions and routes each row to one of multiple output groups.
In IICS Data Integration, what is a 'Mapping Task'?
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.
What is the 'Lookup' transformation in IICS used for?
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.
Which IICS feature allows you to parameterize mapping inputs so the same mapping runs against different sources?
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.
What transformation would you use in IICS to combine rows from two related streams using a common key?
Answer: Joiner
The Joiner transformation merges rows from two input pipelines based on a matching key column, similar to a SQL join.
In IICS Data Integration, what does 'pushdown optimization' do?
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.