Informatica Data Manager

It does not slow down operations ✘ It is capable of given answers ✘ It is more affordable ✘ It is more accurate ✔

Coherent and incoherent table ✘ True and false table ✘ Convention and fact table ✘ Dimension and fact table ✔

5 ✘ 7 ✘ 4 ✘ 2 ✔

It is reusable ✘ It is not reusable ✘ It consists of join transformation ✘ It has procedures ✔

Copying files or folders ✘ Exporting or importing repository ✘ Cutting and pasting files or folders ✘ Using Informatica deployment ✔

RDBMS and HDFS ✘ HDFS and MapReduce ✘ HDFS and Mapplet ✘ MapReduce and Mapplet ✔

CSV ✘ JSON ✘ Avro ✘ Parquet ✔

SQL agent ✘ Sqoop ✘ Hive ✘ SQL profiler ✔