ICC Data Integration & Management 3 — Questions and Answers
Question 1: In IICS Data Integration, which join type returns all rows from the master source and only matching rows from the detail source?
- Full outer join
- Inner join
- Left outer join (master-detail) (Correct answer)
- Right outer join
Correct answer: Left outer join (master-detail)
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?
- 5
- 10
- No fixed limit — depends on license and load balancing needs (Correct answer)
- 3
Correct answer: No fixed limit — depends on license and load balancing needs
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?
- Stored Procedure transformation (Correct answer)
- SQL transformation
- Expression transformation
- Hierarchy Parser
Correct answer: Stored Procedure transformation
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?
- A full table scan on every run
- A watermark column such as a timestamp or sequence ID (Correct answer)
- A CDC log reader on the source database
- A hash comparison of every row
Correct answer: A watermark column such as a timestamp or sequence ID
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?
- Data Integration
- Cloud Application Integration (CAI) (Correct answer)
- API Center
- Mass Ingestion
Correct answer: Cloud Application Integration (CAI)
Cloud Application Integration (CAI) is the Informatica service built for event-driven, API-triggered, and real-time application integration scenarios.
Question 6: In a mapping with a Lookup transformation configured as 'Cached', what happens if the cache file becomes stale?
- IICS automatically refreshes the cache every 10 minutes
- Lookups return NULL for all records until the cache is manually cleared
- Old cached values are returned, potentially causing incorrect matches until the cache is rebuilt (Correct answer)
- The mapping fails immediately with a cache validation error
Correct answer: Old cached values are returned, potentially causing incorrect matches until the cache is rebuilt
A stale lookup cache means the mapping uses outdated reference data, which can produce incorrect lookup results without causing a mapping failure.
Question 7: What is the function of the 'Normalizer' transformation in IICS?
- Converts data to a standard format using regex patterns
- Transposes multiple column occurrences from a single row into multiple rows (Correct answer)
- Removes special characters from string fields
- Ranks records based on a numeric field
Correct answer: Transposes multiple column occurrences from a single row into multiple rows
The Normalizer transformation pivots repeated column groups (e.g., ITEM1, ITEM2, ITEM3) into separate rows, normalizing denormalized flat structures.
ICC Data Integration & Management 3
In IICS Data Integration, which join type returns all rows from the master source and only matching rows from the detail source?