IICS Certification Data Integration in IICS 3

Question 1

Which IICS Data Integration object stores a set of reusable transformation logic that can be called from multiple mappings?

Accepted Answer

Mapplet

Answer

A Mapplet is a reusable sub-mapping that encapsulates transformation logic and can be embedded in multiple mappings.

Question 2

What does the 'Normalizer' transformation do in IICS?

Accepted Answer

Converts multiple column values in a single row into multiple rows

Answer

The Normalizer transformation pivots repeated column groups in a single row into individual rows, normalizing denormalized data.

Question 3

In IICS, what is the purpose of the 'Sequence Generator' transformation?

Accepted Answer

Generates sequential or custom numeric values for each row

Answer

The Sequence Generator produces unique sequential or custom numeric values that can be used as surrogate keys or record IDs.

Question 4

Which output type in IICS Data Integration writes rejected records that fail transformation rules to a separate location?

Accepted Answer

Bad file / Reject rows output

Answer

Rejected rows — records that fail validation or transformation rules — can be routed to a bad file or reject output for review.

Question 5

What is 'incremental loading' in the context of IICS Data Integration?

Accepted Answer

Loading only new or changed records since the last run rather than all data

Answer

Incremental loading extracts and loads only records that are new or modified since the last successful run, reducing processing time.

IICS Certification Practice Test