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 Data Integration object stores a set of reusable transformation logic that can be called from multiple mappings?
Answer: Mapplet
A Mapplet is a reusable sub-mapping that encapsulates transformation logic and can be embedded in multiple mappings.
What does the 'Normalizer' transformation do in IICS?
Answer: Converts multiple column values in a single row into multiple rows
The Normalizer transformation pivots repeated column groups in a single row into individual rows, normalizing denormalized data.
In IICS, what is the purpose of the 'Sequence Generator' transformation?
Answer: Generates sequential or custom numeric values for each row
The Sequence Generator produces unique sequential or custom numeric values that can be used as surrogate keys or record IDs.
Which output type in IICS Data Integration writes rejected records that fail transformation rules to a separate location?
Answer: Bad file / Reject rows output
Rejected rows — records that fail validation or transformation rules — can be routed to a bad file or reject output for review.
What is 'incremental loading' in the context of IICS Data Integration?
Answer: Loading only new or changed records since the last run rather than all data
Incremental loading extracts and loads only records that are new or modified since the last successful run, reducing processing time.
In IICS Data Integration, what does the 'Union' transformation do?
Answer: Combines rows from multiple input pipelines into a single output stream
The Union transformation concatenates rows from multiple input pipelines into one output stream, similar to a SQL UNION ALL.