Multiple choice etl

Informatica supports

  1. Only Heterogeneous source

  2. Only heterogeneous Target

  3. Heterogeneous source and target

  4. Only homogeneous source and target

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Informatica PowerCenter supports heterogeneous sources and targets - meaning it can extract data from one type of source system (e.g., Oracle) and load it into a different type of target system (e.g., SQL Server, flat file, XML) in the same workflow. This is a core ETL capability. Option A and B are incorrect because Informatica is not limited to only heterogeneous on one side. Option D is incorrect because Informatica specifically supports and is designed for cross-platform (heterogeneous) data integration.