ICC Data Integration & Management 2

Question 1

Which Informatica IICS component is responsible for executing mappings and tasks at runtime?

Accepted Answer

Data Integration Server (Secure Agent)

Answer

The Secure Agent is the runtime engine that executes mappings, tasks, and workflows on-premises or in cloud environments.

Question 2

In IICS, what is the purpose of a Connection in a mapping?

Accepted Answer

To provide credentials and endpoint details for a data source or target

Answer

A Connection stores the credentials, host, port, and other configuration needed to connect to a source or target system.

Question 3

What does a Pushdown Optimization (PDO) setting of 'Full' do in an IICS mapping?

Accepted Answer

Pushes all supported transformation logic to the source or target database engine

Answer

Full PDO instructs IICS to push as much transformation logic as possible down to the database, reducing data movement.

Question 4

Which transformation in IICS Data Integration is used to remove duplicate rows from a data set?

Accepted Answer

Duplicate Record Exception

Answer

The Duplicate Record Exception transformation identifies and routes or removes duplicate records based on specified key fields.

Question 5

When configuring an IICS Taskflow, what is a Decision task used for?

Accepted Answer

To branch the flow based on a conditional expression evaluation

Answer

A Decision task evaluates a Boolean expression and routes execution to different branches depending on true or false outcome.

(ICC) Informatica Cloud Certification Practice Test