ICC Data Integration & Management 4

Question 1

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

Accepted Answer

Database ingestion with CDC (Change Data Capture)

Answer

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

Question 2

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

Accepted Answer

Dynamic mapping with schema at run time

Answer

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

Question 3

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

Accepted Answer

Merges multiple input pipelines with identical schemas into a single pipeline

Answer

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

Question 4

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

Accepted Answer

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

Answer

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.

Question 5

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

Accepted Answer

File listener / event-based trigger

Answer

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

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Data Integration & Management 4