ICC Data Integration & Management 3

Question 1

In IICS Data Integration, which join type returns all rows from the master source and only matching rows from the detail source?

Accepted Answer

Left outer join (master-detail)

Answer

In IICS Joiner transformation, a Master-Detail (left outer) join returns every master row and matched detail rows, with NULLs for unmatched detail columns.

Question 2

What is the maximum number of active Secure Agents that can be grouped in a single Secure Agent Group?

Accepted Answer

No fixed limit — depends on license and load balancing needs

Answer

IICS does not impose a hard cap on Secure Agents per group; the number depends on your organization's license and load-balancing requirements.

Question 3

Which IICS transformation would you use to call a stored procedure in a relational database during a mapping?

Accepted Answer

Stored Procedure transformation

Answer

The Stored Procedure transformation is specifically designed to call database stored procedures and retrieve output parameters during mapping execution.

Question 4

In IICS, what does the 'Incremental Load' pattern typically use to identify new or changed records?

Accepted Answer

A watermark column such as a timestamp or sequence ID

Answer

Incremental loads commonly filter source rows using a high-watermark value (e.g., last modified timestamp) stored from the previous successful run.

Question 5

Which IICS service handles REST API-based integration flows triggered by external events?

Accepted Answer

Cloud Application Integration (CAI)

Answer

Cloud Application Integration (CAI) is the Informatica service built for event-driven, API-triggered, and real-time application integration scenarios.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Data Integration & Management 3