Data Integration & Management Flashcards

In IICS, which connector type would you use to integrate with Salesforce and automatically handle bulk API vs. REST API switching based on volume?

Answer: Salesforce connector (IICS native)

The native IICS Salesforce connector automatically selects Bulk API or SOAP/REST API based on row volume thresholds and configured settings.

What is the effect of enabling 'High Availability' for a Secure Agent Group in IICS?

Answer: If one agent fails, another agent in the group automatically picks up and runs the task

High availability in a Secure Agent Group means IICS will failover task execution to another healthy agent in the group if the primary agent becomes unavailable.

Which IICS Data Integration transformation is best suited for parsing a nested JSON or XML hierarchy into relational rows?

Answer: Hierarchy Parser

The Hierarchy Parser transformation flattens nested JSON or XML documents into relational output groups, mapping hierarchical nodes to flat rows.

In IICS, what happens when a mapping with 'Stop on Errors' set to 1 encounters its first row error?

Answer: The mapping immediately stops and marks the run as failed

When Stop on Errors is set to 1, IICS halts execution after the first row-level error and marks the session as failed.

Which IICS feature provides data lineage tracking and impact analysis across mappings, tasks, and connections?

Answer: Data Catalog (Axon / EDC integration)

Informatica's Enterprise Data Catalog (EDC) and Axon integration provide automated lineage discovery and impact analysis across IICS assets.

When configuring a target in IICS with the 'Update Else Insert' (Upsert) operation, what must be defined to identify existing records?

Answer: One or more key fields used to match source rows to target rows

For an upsert operation, IICS uses the designated key fields to look up matching target rows; a match triggers an update, no match triggers an insert.

In IICS, what is the primary purpose of the 'Data Validation Option' (DVO) add-on?

Answer: To compare source and target row counts and data values to certify migration accuracy

DVO runs automated source-to-target reconciliation tests (row counts, aggregates, sample data) to validate that a migration or load completed accurately.