Data Integration & Management Flashcards

In IICS Mass Ingestion, which ingestion type is used to continuously replicate data changes from a source database to a target?

Answer: Database ingestion with CDC (Change Data Capture)

Database ingestion with CDC reads the source database transaction log to capture inserts, updates, and deletes in near real-time for continuous replication.

Which IICS feature allows you to parameterize a mapping so the same design can run against different source tables at runtime?

Answer: Dynamic mapping with schema at run time

Dynamic mappings allow the source or target schema to be resolved at runtime using parameters, enabling one mapping to process multiple tables.

In IICS Data Integration, what is the purpose of the 'Union' transformation?

Answer: Merges multiple input pipelines with identical schemas into a single pipeline

The Union transformation combines rows from two or more upstream pipelines with compatible schemas into one output pipeline, similar to SQL UNION ALL.

What does setting the 'Tracing Level' to 'Verbose Data' in an IICS mapping do?

Answer: Logs all input and output row data for every transformation, useful for deep debugging

Verbose Data tracing writes row-level data values through each transformation to the session log, providing maximum visibility for debugging but at significant performance cost.

Which scheduling option in IICS allows a task to run automatically whenever a file is dropped into a specified location?

Answer: File listener / event-based trigger

An event-based trigger (file listener) monitors a directory or cloud storage path and fires the task automatically when a new file arrives.

In IICS, what is the difference between a 'reusable transformation' and a 'mapplet'?

Answer: A reusable transformation is a single transformation instance; a mapplet is a reusable pipeline segment containing multiple transformations

A reusable transformation is one saved transformation instance reused across mappings, while a mapplet encapsulates an entire sub-pipeline with multiple transformations as a single reusable unit.

When using the IICS REST V3 API to run a task programmatically, which HTTP method and endpoint are used to start a Mapping Configuration Task?

Answer: POST /api/v3/jobs with task type and task ID in the body

You POST to /api/v3/jobs with a JSON body specifying the task type (e.g., MCT) and task ID to trigger execution via the IICS REST API.