ETL (Extract, transform, load) Question:

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.


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