Oracle Extract transform load (ETL) Question:
Download Questions PDF

What is a mapping, session, worklet, workflow, mapplet?

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 Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
How can we use mapping variables in Informatica? Where do we use them?What is Informatica Metadata and where is it stored?