40+ Top Interview Questions and Answers (2024)

Ques 1

Explain the difference between ETL and ELT.

ETL (Extract, Transform, Load) is a process where data is extracted from source systems, transformed, and then loaded into a data warehouse. ELT (Extract, Load, Transform) is a process where data is first extracted and loaded into the target system, and then transformations are applied.

Simpan untuk Revisi

Bookmark item ini, tandai sebagai sulit, atau masukkan ke dalam set revisi.

Bangun keterampilan dengan jalur belajar terfokus, tes simulasi, dan konten siap wawancara.

Interview Questions and Answers

The Best LIVE Mock Interview - You should go through before interview

Interview Questions and Answers

Intermediate / 1 to 5 years experienced level questions & answers

Explain the difference between ETL and ELT.

Simpan untuk Revisi

Explain the difference between a Mapping and a Mapplet.

Simpan untuk Revisi

Explain the concept of a Router transformation.

Simpan untuk Revisi

What is a Repository Service in Informatica?

Simpan untuk Revisi

What is a Rank transformation, and how is it used?

Simpan untuk Revisi

Explain the concept of a Lookup transformation.

Simpan untuk Revisi

What is the difference between a connected and an unconnected Lookup transformation?

Simpan untuk Revisi

How is parameterization achieved in Informatica?

Simpan untuk Revisi

Explain the concept of Partitioning in Informatica.

Simpan untuk Revisi

How can you handle errors in Informatica?

Simpan untuk Revisi

Explain the concept of a Normalizer transformation.

Simpan untuk Revisi

Explain the concept of Data Transformation Manager (DTM) in Informatica.

Simpan untuk Revisi

How can you improve session performance in Informatica?

Simpan untuk Revisi

How does Informatica handle incremental data loading?

Simpan untuk Revisi

What is the purpose of a Debugger in Informatica?

Simpan untuk Revisi

What is a Transaction Control transformation?

Simpan untuk Revisi

How can you handle slowly changing dimensions in Informatica?

Simpan untuk Revisi

What is the purpose of a Target Load Plan in Informatica?

Simpan untuk Revisi

Explain the concept of a Sorter transformation.

Simpan untuk Revisi

Explain the concept of a Surrogate Key in Informatica.

Simpan untuk Revisi

What is the purpose of a Pre-Session Command in Informatica?

Simpan untuk Revisi

What is the purpose of a Data Masking transformation?

Simpan untuk Revisi

What is the purpose of a LookUp cache in Informatica?

Simpan untuk Revisi

What is the purpose of a Normalizer transformation in Informatica?

Simpan untuk Revisi

Most helpful rated by users:

Related interview subjects

All interview subjects

WithoutBook