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

Taskflow

Answer

Mapping Task

Answer

Process

Question 2

What does the 'Normalizer' transformation do in IICS?

Accepted Answer

Converts multiple column values in a single row into multiple rows

Answer

Removes NULL values from the pipeline

Answer

Joins two data streams

Answer

Calculates aggregate functions

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

Orders rows by a numeric key

Answer

Generates test data for debugging

Answer

Creates primary keys in the target database

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

Error log

Answer

Debug log

Answer

Audit table

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

Loading data in alphabetical order

Answer

Loading data in parallel across multiple nodes

Answer

Loading data only during off-peak hours

Question 6

In IICS Data Integration, what does the 'Union' transformation do?

Accepted Answer

Combines rows from multiple input pipelines into a single output stream

Answer

Merges two streams by matching on a key column

Answer

Removes duplicate rows across pipelines

Answer

Filters rows that do not match a condition