ICC System Architecture & Design 3 — Questions and Answers
Question 1: In Informatica Cloud Data Integration, which transformation is used to route rows to different targets based on a condition?
- Filter
- Router (Correct answer)
- Joiner
- Normalizer
Correct answer: Router
The Router transformation evaluates conditions on each row and directs it to the appropriate output group based on those conditions.
Question 2: Which IICS design pattern should be used when real-time event-driven integration is required between cloud applications?
- Batch mapping with scheduler
- Cloud Application Integration with process flows (Correct answer)
- Replication task
- Mass ingestion task
Correct answer: Cloud Application Integration with process flows
Cloud Application Integration supports event-driven architectures using process flows, API services, and triggers for real-time integration.
Question 3: What is the primary architectural advantage of using pushdown optimization in IICS mappings?
- It offloads transformation logic to the database engine, reducing data movement (Correct answer)
- It compresses data during transfer to increase speed
- It enables parallel agent execution
- It caches source data in the Informatica Cloud
Correct answer: It offloads transformation logic to the database engine, reducing data movement
Pushdown optimization translates mapping logic into SQL and executes it on the source or target database, minimizing data movement to the agent.
Question 4: In IICS, which feature allows a single mapping to dynamically switch its source or target object at runtime?
- Parameterization (Correct answer)
- Lookup override
- Pushdown optimization
- Dynamic schema handling
Correct answer: Parameterization
Parameterization lets you define parameters for connection names, object names, and filter conditions, enabling the same mapping to run against different sources or targets.
Question 5: Which IICS service is best suited for ingesting large volumes of data from files into a cloud data warehouse like Snowflake?
- Cloud Application Integration
- Mass Ingestion — Files (Correct answer)
- Cloud Data Quality
- Cloud Data Governance
Correct answer: Mass Ingestion — Files
Mass Ingestion — Files is designed to efficiently load large file datasets into cloud data warehouses and data lakes at scale.
Question 6: When designing a mapping for Slowly Changing Dimension (SCD) Type 2 in IICS, which transformation pair is typically required?
- Sorter and Aggregator
- Lookup and Update Strategy (Correct answer)
- Filter and Router
- Joiner and Union
Correct answer: Lookup and Update Strategy
A Lookup identifies existing records, and an Update Strategy determines whether to insert new versions or update flags for SCD Type 2 historical tracking.
Question 7: In an IICS multi-org architecture, what is the purpose of a sub-organization?
- To run a secondary Secure Agent group
- To isolate assets and users for different business units within a parent organization (Correct answer)
- To create a backup of the parent organization's assets
- To enable cross-cloud data replication
Correct answer: To isolate assets and users for different business units within a parent organization
Sub-organizations allow enterprises to segment users, assets, and connections by business unit while still being managed under a parent organization.
ICC System Architecture & Design 3
In Informatica Cloud Data Integration, which transformation is used to route rows to different targets based on a condition?