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

Please subscribe on my YouTube Channel.

Definitions.


Mapping
A mapping represents data flow from sources to targets. 

Mapping represents the flow and transformation of data from source to target. 

Represents flow of data from source to destination



Mapplet
A mapplet creates or configures a set of transformations. 

A group of transformations that can be called within a mapping. 

A set of transformations that can be called within a mapping


WorkFlow
A workflow is a set of instruction that tells the Informatica server how to execute the tasks. 

Controls the execution of tasks such as commands, emails, and sessions. 

A workflow is a set of instruction on how to execute tasks such as sessions (mappings), sending email, os commands (shell/batch) etc.


A workflow is an execution wrapper around tasks and/or worklets.

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

A workflow that can be called within a workflow.

set of sessions

A worklet is a set of instructions that can be reused in several workflows. 

A worklet is a group of tasks combined that can be reused in multiple workflows.


Worklets are objects that represent a set of workflow tasks that allow reusing a set of workflow logic.

Use of Worklet:- You can bind many of the tasks in one place so that they can easily get identified and also they can have a specific purpose.


Session 
A session is a set of instructions to move data from sources to targets.

A task associated with a mapping to define the connections and other configurations for that mapping. 

A set of instructions which describes the data movement from source to destination

No comments:

Post a Comment

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...