ETL (Extract, transform, load) Question:

Download Job Interview Questions and Answers PDF

Explain a mapping, session, worklet, workflow, mapplet?

Extract, transform, load (ETL) Interview Question
Extract, transform, load (ETL) Interview Question

Answer:

A mapping represents dataflow from sources to targets.
A mapplet creates or configures a set of transformations.

A workflow is a set of instruction sthat tell the Informatica server how to execute the tasks.

A worklet is an object that represents a set of tasks.

A session is a set of instructions that describe how and when to move data from sources to targets.

Download Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is Full load & Incremental or Refresh load?Tell me what is Full load & Incremental or Refresh load?