Difference between Mapping Parameters and Variables

A mapping parameter represents a constant value that we can define before running a session. A mapping parameter retains the same value throughout the entire session. If we want to change the value of a mapping parameter between session runs we need to Update the parameter file.

A mapping variable represents a value that can change during the session. The Integration Service saves the value of a mapping variable to the repository at the end of each successful session run and uses that value the next time when we run the session. Variable functions like SetMaxVariable, SetMinVariable, SetVariable, SetCountVariable are used in the mapping to change the value of the variable. At the beginning of a session, the Integration Service evaluates references to a variable to determine the start value. At the end of a successful session, the Integration Service saves the final value of the variable to the repository. The next time we run the session, the Integration Service evaluates references to the variable to the saved value. To override the saved value, define the start value of the variable in the parameter file.

Unable to stop/abort workflow/Session - Option Disabled

1) Try disconnecting and reconnection.
2) If above doesn't work try closing the folder and Open it again in Workflow Monitor - It worked for me.

Output column mismatch. User defined SQL query in Source Qualifier

The Logic 

1) The number of fields selected in the SQL override query should match the number the number of ports in the Source qualifier which are LINKED to the next transformation. The names are not required to be the same but order needs to be the same.

Interestingly Informatica maps the fields from the SQL query to the Source qualifier output links instead of Source Qualifier ports. So the first column in the SQL query gets mapped to the first link, the second column to the second link and so on.

2) Also, all the ports in the Source Qualifier transformation need to be linked with the Source definition.

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

can we run a worklet with out work flow?

No, You cannot run a worklet without a workflow.

A worklet is similar to a workflow with two differences:

First, a worklet does not have a Start task. So in order to execute anything within a mapplet, you need a workflow into which you can embed the worklet.

Second, worklet can be made reusable (if you want to group functionality into a worklet), but you don't have to; workflows are never reusable.

Informatica - How to Invoke a Powershell Script from Command Task

Please subscribe on my YouTube Channel.

Command to Invoke Powershell Script 

echo off | Powershell.exe -executionpolicy remotesigned -File C:\filePath\Scripts\poweshellScript.ps1