1. What is Informatica IDMC CDI?

Answer:
Informatica IDMC – Cloud Data Integration (CDI) is a cloud-native ETL/ELT service that enables data extraction, transformation, and loading across cloud and on-prem systems. It supports real-time, batch, serverless, and advanced transformations with high scalability.

2. What are the key components of Informatica CDI?

Answer:

• Mappings

• Mapping Tasks (MTT)

• Taskflows (orchestration)

• Connections

• Secure Agent

• Advanced & Intelligent Transformations

• Monitor & Operational Insights

3. What is a Secure Agent? Why is it important?

Answer:
Secure Agent is a lightweight runtime installed on-prem or cloud VM. It handles:

• Data movement

• Execution of mappings

• Connectivity to local sources

• Encryption & security

It ensures CDI can access on-prem databases securely.

4. What are Mapping Tasks (MTT)?

Answer:
A Mapping Task is a runnable instance of a mapping. It allows parameterization, scheduling, and deploying mappings in production for operational use.

5. What is the difference between Mapping and Taskflow?

Answer:

• Mapping → Defines the ETL/ELT logic.

• Taskflow → Orchestrates multiple tasks (MTTs, DTTs, notification tasks, conditional paths, loops).

6. What transformations are commonly used in CDI?

Answer:

• Filter

• Expression

• Lookup (Connected / Unconnected)

• Joiner

• Aggregator

• Router

• Source/Target

• Rank

• Normalizer (limited)
  Plus advanced transformations like:

• Dynamically Linked Mapplets

• Mass Ingestion

• AI-assisted transformations

7. What is Pushdown Optimization?

Answer:
Pushdown Optimization (PDO) pushes ETL logic to the source or target database, reducing data movement and improving performance. Types:

• Source Pushdown

• Target Pushdown

• Full Pushdown

8. How does CDI handle real-time integration?

Answer:
Using:

• CDC (Change Data Capture)

• Streaming ingestion

• Serverless tasks

• API-triggered taskflows

9. Explain Parameterization in CDI.

Answer:
Parameters allow mappings and tasks to be dynamic and flexible for production. Common parameters:

• File names / DB tables

• Paths

• Connection values

• Filter conditions

• Workflow variables

Parameters are defined using parameter files or directly within mapping tasks.

10. How do you monitor tasks in Informatica CDI?

Answer:
Using the Monitor tab to see:

• Task execution pipeline

• Logs & statistics

• Throughput

• Errors

• Alerting

• Operational Insights (OI) for automated observability, cost monitoring, and performance analytics.