informatica assignment task variable

Learning Informatica PowerCenter 9.x by Rahul Malewar

Get full access to Learning Informatica PowerCenter 9.x and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

The assignment task

The assignment task is used to assign a value to user-defined variables in Workflow Manager.

Before you can define a variable in the assignment task, you need to add the variable in Workflow Manager. To add a variable to the Workflow, perform the following steps:

A new variable is created, as shown in the preceding screenshot. The new variable that is created is $$NEWVARIABLE1 . You can ...

Get Learning Informatica PowerCenter 9.x now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Informatica Complete Reference

• INFORMATICA INTRODUCTION
• TRANSFORMATIONS LIST
• ADVANCE TOPICS
• Informatica Scenarios
• Informatica Questions
• Datawarehousing

Social Profiles

Informatica introduction.

• What is Informatica
• Informatica 9x Architecture
• Powercenter Integration Service 9
• Informatica Software Architecture 8x
• Informatica Server 9.1.0 Install and Configure
• Informatica Server upgrade 9.1.0 to 9.5.0
• Informatica Client Tool 9.1.0 Installation
• Informatica Client Tools
• How to Add Repository and Connect It

Transformations List

• List of Transformations in Designer
• Source Qualifier
• SQL Transformation
• Sequence Generator
• Stored Procedure
• Transaction Control
• Update Strategy
• XML Generator
• Workflow Manager Overview
• List of Tasks in Workflow Manager
• Command Task
• Control Task
• Event Wait Task
• Event Raise Task
• Decision Task

Assignment Task

Advance topics.

• Few Featured Informatica 9
• Tools Included in Informatica 9
• Types of Repositories
• Shortcut Keys in Informatica Powercenter
• Transformations Naming Conventions
• Informatica Performance Tuning
• Import Flat File Definition
• Import Relational Definition
• Dynamic Lookup
• Working with Excel Source File
• File List / Indirect Load
• Mapping Parameters & Variables
• Advance Mapping Parameters & Variables
• Parameter File
• Constraint-Based Loading
• User-Defined Function
• Tips and Important Concepts
• Database and Informatica capabilities
• Mapping Optimization Techniques
• SQL - Script Mode Static
• SQL - Script Mode Dynamic(Connection Object)
• SQL - Script Mode Dynamic(Full Connection)
• SQL - Query Mode Static
• SQL - Query Mode Dynamic (Connection Object)
• SQL - Query Mode Dynamic (Full Connection)
• Currently Processed File Name
• Slowly Changing Dimension Type 1
• Slowly Changing Dimension Type 2 - Effective Date Range
• Slowly Changing Dimension Type 3

FaceBook Follows

Friday, June 21, 2013

8 comments:

Hi Admin, May I know how are you increasing value by one for $$Session_Counter after each successful run?

Hi Vaibhav, Please see about post 9th point. 9. Enter the value or expression you want to assign. If you have still doubt, please let me know.

Hi..nice solution...but i have multiple sessions in my workflow..is there any other technique than using assignment task at session level

Hi goutham, I don't how to assign the values of workflow variables to target.

How can we solve that when the source file getting along with date and time ,but we do not require that date and time with document name as target

can we assign the the value of variable in the parameter file?

Si así lo requieres si se puede asignar desde un archivo de parámetros pero depende de la necesidad.

Hi ! Alice this side from Sample Assignment. It is said that by taking affordable Electrical Engineering assignments Help from these service providers, students can clear their courses with the best academic grades. Sample Assignment provide lots of benefits to students along with their assignment help online services in Australia, such as 24*7 client support service, live interactive sessions with subject matter experts, lucrative offers and deals, etc.

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

Informatica PC: how do I make a decision in the flow upon scalar query result?

I'm struggling with what seems like the simplest thing there is: assigning a value to a mapping variable that I later on use in my flow to make a decision upon... With my MS SSIS background this is a 10 seconds task, however in Informatica PowerCenter, it is taking me hours...

So I have a mapping variable $$V_FF and a workflow variable $$V_FF. At first the names were different but while trying things out, I changed that. But that shouldn't matter, right?

In a mapping, I have a view as a source that returns -1, 0 or 1. The mapping variable aggregate function is set to MIN.

In the session that I have created for this mapping, I have a post-session assignment between the wf variable and the mapping variable. In this mapping I use setvariable function in an Extrans block.

Every time I run the wf, I see in the log that it uses a persistent value instead of assigning a new value everytime the flow is running...

What am I missing here?

Thanks in advance!

• informatica-powercenter

• As you have set the aggregation type for the variable to MIN, it will use the minimum of the stored and new value you are setting using setVariable function. So, if the new value is greater than the stored value, it will not change the persistent value. –  Samik Commented Oct 28, 2016 at 18:00

2 Answers 2

Well, the variables here work in a bit different way indeed. So it would be easier to come up with a good answer or you'd explain the whole scenario: what are you using the variable for?

Anyway, the variable values are persisted in repository and reused, as you've noticed. For your scenario you could add an Assignment Task to the Workflow before your Session. Set some low value (eg. -1 if you expect your variable to have some positive value after the Mapping run) and use PreSession Variable Assignment to pass the value to the Mapping. This will override the use of persisted repository value. If course in this case you will need to use Max aggregation.

In the end, I managed to accomplish what I wanted back then. There might be a better way, but this solution is easy to maintain and easy to understand.

• Create a variable in your workflow, lets say $$FailureFlag with type integer.
• Create a view in your DB that returns 1 row with a integer value between 0 and x, where x is a positive integer value.
• Create a mapping with the view that we just created as the source and use a dummy table as destination.
• In this mapping you also create a variable, lets say $$MYVAR, with type integer and aggregation "Count". In an "Expression Transformation" I assign the result of the view, column FF, to this variable $$MYVAR by using SETVARIABLE($$MYVAR,FF).
• From this mapping, create a session in your workflow. In the Components tab, in the "Postsession_success_variable_mapping" section, add a row and link workflow variable $$FailureFlag with session variable $$MYVAR.
• Add a Decision component right after the session you just created, and test the content of your workflow variable, for example $$V_FAILURE_FLAG_IMX = 1.
• Connect your decision then with your destination and add a test clause for example: "$MyDecision.Condition = true AND $MyDecision.PrevTaskStatus = succeeded"

Voila, that's it.

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged variables persistent informatica-powercenter or ask your own question .

• Featured on Meta
• Upcoming sign-up experiments related to tags
• Policy: Generative AI (e.g., ChatGPT) is banned
• The [lib] tag is being burninated
• What makes a homepage useful for logged-in users

Hot Network Questions

• Cloud masking ECOSTRESS LST data
• Is there any other reason to stockpile minerals aside preparing for war?
• Specific calligraphic font for lowercase g
• Was Paul's Washing in Acts 9:18 a Ritual Purification Rather Than a Christian Baptism?
• Why was the animal "Wolf" used in the title "The Wolf of Wall Street (2013)"?
• Predictable Network Interface Names: ensX vs enpXsY
• What is the original source of this Sigurimi logo?
• What is the translation of misgendering in French?
• I wanna start making scripts for my own Indie animation series, but can't find a good way to start it
• Does the Ogre-Faced Spider regenerate part of its eyes daily?
• Would the command spell fail if the commanded action becomes directly harmful later on, but initially appears benign?
• Would the category of directed sets be better behaved with the empty set included, or excluded?
• Should I accept an offer of being a teacher assistant without pay?
• Do I need to indicate 'solo' for wind/brass instruments in shared staff?
• Why we use trace-class operators and bounded operators in quantum mechanics?
• Summation not returning a timely result
• How do guitarists remember what note each string represents when fretting?
• Do known physical systems all have a unique time evolution?
• What are these courtesy names and given names? - confusion in translation
• How to engagingly introduce a ton of history that happens in, subjectively, a moment?
• What’s the highest salary the greedy king can arrange for himself?
• Where can I access records of the 1947 Superman copyright trial?
• What could explain that small planes near an airport are perceived as harassing homeowners?
• Intersection in toric variety

Mapping Task Output

System-Defined Mapping Outputs

• English English
• Español Spanish
• Deutsch German
• Français French
• 日本語 Japanese
• Português Portuguese
•        
• PowerCenter

Advanced Workflow Guide

• Updated : January 2023
• PowerCenter 10.5
• All Products

Rename Saved Search

Confirm Deletion

Are you sure you want to delete the saved search?

Table of Contents

• Understanding Pipeline Partitioning Overview
• Partition Points
• Partitioning Multiple Input Group Transformations
• Partition Types
• Configuring Dynamic Partitioning
• Rules and Guidelines for Dynamic Partitioning
• Using Dynamic Partitioning with Partition Types
• Configuring Partition-Level Attributes
• Cache Partitioning
• Mapping Variables in Partitioned Pipelines
• Before You Create a Session
• After You Create a Session with Multiple Partitions
• Partition Restrictions for PowerExchange
• Adding Partition Points to a Pipeline
• Configuring a Partition Point
• Edit Partition Point
• Edit Partition Key
• Non-Partition Points Node
• Partition Points Overview
• Rules and Guidelines for Adding and Deleting Partition Points
• Entering an SQL Query
• Entering a Filter Condition
• Rules and Guidelines for Partitioning File Sources
• Using One Thread to Read a File Source
• Using Multiple Threads to Read a File Source
• Configuring Sessions to Use a Single Thread
• Configuring Sessions to Use Multiple Threads
• Configuring Concurrent Read Partitioning
• Database Compatibility
• Configuring Connection Settings
• Configuring Commands for Partitioned File Targets
• Configuring Merge Options
• Working with Multiple Partitions
• Creating Partition Points
• One Input Group
• Multiple Input Groups
• Partitioning Sorted Joiner Transformations
• Using 1:n Partitions
• Using n:n Partitions
• Using Sorter Transformations
• Add a Hash Auto-keys Partition Upstream of the Sort Origin
• Use n:n Partitions
• Sharing Partitioned Caches
• Partitioning Pipeline Lookup Transformation Cache
• Partitioning Sequence Generator Transformations
• Configuring Sorter Transformation Work Directories
• Partitioning XML Generator Transformations
• Restrictions for Numerical Functions
• Setting Partition Types in the Pipeline
• Setting Partition Types
• Database Partitioning with One Source
• Partitioning a Source Qualifier with Multiple Sources
• Integration Service Handling with Source Database Partitioning
• Rules and Guidelines for Source Database Partitioning
• Rules and Guidelines for Target Database Partitioning
• Hash Auto-Keys Partition Type
• Hash User Keys Partition Type
• Adding a Partition Key
• Adding Filter Conditions
• Rules and Guidelines for Creating Key Ranges
• Pass-Through Partition Type
• Round-Robin Partition Type
• Pushdown Optimization Overview
• Running Source-Side Pushdown Optimization Sessions
• Running Target-Side Pushdown Optimization Sessions
• Integration Service Behavior with Full Optimization
• Active and Idle Databases
• Pushdown Optimization to Databases Using the ODBC Connection
• Comparing the Output of the Integration Service and Databases
• Rules and Guidelines for IBM DB2
• Rules and Guidelines for Netezza
• Rules and Guidelines for Teradata
• Rules and Guidelines for Vertica
• Rules and Guidelines for Microsoft Azure SQL Data Warehouse
• Incompatible Users for Database Connections
• Qualifying Names of Tables in Idle Databases
• Date Compatibility
• Operator Compatibility
• Variable Compatibility
• Amazon Redshift Function Exceptions
• Google BigQuery Function Exceptions
• Snowflake Function Exceptions
• Greenplum Function Exceptions
• Netezza Function Exceptions
• PostgreSQL Function Exceptions
• Teradata Function Exceptions
• Vertica Function Exceptions
• Functions for Enterprise Applications
• Relational Database Function Exceptions
• Error Handling
• Working with Slowly Changing Dimensions
• Sequence Creation Example
• View Creation Example
• Identifying Orphaned Objects Using Session Logs
• Identifying Orphaned Objects Using an SQL Query
• Removing the Orphaned Objects
• Using the $$PushdownConfig Mapping Parameter
• Pushdown Options
• Pushdown Optimization for Pass-Through Partitioning
• Pushdown Optimization for Key-Range Partitioning
• Example of Pushdown Optimization for Session with Multiple Partitions
• Rules and Guidelines for Sessions with Multiple Partitions
• Target Load Rules
• Viewing Pushdown Groups
• General Pushdown Restrictions
• Aggregator Transformation
• Expression Transformation
• Filter Transformation
• Joiner Transformation
• Unconnected Lookup Transformation
• Lookup Transformation with an SQL Override
• Router Transformation
• Sequence Generator Transformation
• Sorter Transformation
• Source Qualifier Transformation with an SQL Override
• Union Transformation
• Update Strategy Transformation
• Real-time Processing Overview
• Messages and Message Queues
• Web Service Messages
• Change Data from PowerExchange CDC Sources
• Configuring Real-time Sessions
• Message Count
• Reader Time Limit
• Flush Latency
• Commit Type
• Prerequisites
• Steps to Enable Message Recovery
• Message Recovery for JMS and WebSphere MQ Sources
• Message Recovery for SAP IDoc, TIBCO, and webMethods Sources
• Message Recovery
• Session Recovery Data Flush
• PM_REC_STATE Table
• Message Processing
• Recovery Ignore List
• Stopping Real-time Sessions
• Restarting Real-time Sessions
• Recovering Real-time Sessions
• Restart and Recover Commands
• Rules and Guidelines for Real-time Sessions
• Rules and Guidelines for Message Recovery
• Real-time Processing Example
• PowerCenter Real-time Products
• Commit Points Overview
• Target-Based Commits
• Determining the Commit Source
• Connecting XML Sources in a Mapping
• Connecting Multiple Output Group Custom Transformations in a Mapping
• Rollback Evaluation
• Roll Back Open Transaction
• Roll Back on Error
• Roll Back on Failed Commit
• Transformation Scope
• Understanding Transaction Control Units
• Rules and Guidelines for Working with Transaction Control
• Creating Target Files by Transaction
• Setting Commit Properties
• Error Log Code Pages
• PMERR_TRANS
• Understanding the Error Log File
• Configuring Error Log Options
• Workflow Recovery Overview
• Workflow State of Operation
• Session State of Operation
• Creating Target Recovery Tables
• Recovery Options
• Configuring Suspension Email
• Recovering Stopped, Aborted, and Terminated Workflows
• Recovering Suspended Workflows
• Command Task Strategies
• Session Task Strategies
• Automatically Recovering Terminated Tasks
• Resuming Sessions
• Relational Source
• Flat File Source
• Output is Deterministic
• Output is Repeatable
• Configuring a Mapping for Recovery
• Recovering a Workflow Using the Workflow Monitor
• Recovering a Session
• Recovering a Workflow From a Session
• Configuring Recovery to Resume from the Last Checkpoint
• Unrecoverable Workflows or Tasks
• Stopping and Aborting Overview
• Threshold Errors
• Fatal Errors
• Integration Service Handling for Session Failure
• Stopping or Aborting a Session Task
• Steps to Stop or Abort
• Concurrent Workflows Overview
• Recovering Workflow Instances by Instance Name
• Rules and Guidelines for Running Concurrent Instances of the Same Instance Name
• Running Concurrent Web Service Workflows
• Configuring Workflow Instances of the Same Name
• Recovering Workflow Instances of the Same Name
• Accessing the Run Instance Name or Run ID
• Steps to Configure Concurrent Workflows
• Starting Workflow Instances from Workflow Designer
• Starting One Concurrent Workflow
• Creating Workflow Instances from the Command Line
• Stopping or Aborting Concurrent Workflows
• Monitoring Concurrent Workflows
• Log Files for Unique Workflow Instances
• Log Files for Workflow Instances of the Same Name
• Rules and Guidelines for Concurrent Workflows
• Grid Processing Overview
• Running Workflows on a Grid
• Running Sessions on a Grid
• Forming Partition Groups Without Resource Requirements
• Forming Partition Groups With Resource Requirements
• Rules and Guidelines for Creating Partition Groups
• Working with Caches
• Grid Connectivity and Recovery
• Rules and Guidelines for Configuring a Workflow or Session to Run on a Grid
• Load Balancer Overview
• Assigning Service Levels to Workflows
• Assigning Resources to Tasks
• Workflow Variables Overview
• Using Predefined Workflow Variables in Expressions
• Evaluating Condition in a Workflow
• Evaluating Task Status in a Workflow
• Evaluating Previous Task Status in a Workflow
• Workflow Variable Start and Current Values
• Datatype Default Values
• Creating User-Defined Workflow Variables
• Persistent Worklet Variables
• Overriding the Initial Value
• Rules and Guidelines for Using Worklet Variables
• Passing Variable Values between Worklets

Configuring Variable Assignments

• Changing the Session Log Name
• Changing the Target File and Directory
• Changing Source Parameters in a File
• Changing Connection Parameters
• Getting Run-Time Information
• Rules and Guidelines for Creating File Parameters and Database Connection Parameters
• Mapping Parameters and Variables in Sessions
• Passing Parameter and Variable Values between Sessions
• Parameter Files Overview
• Parameter and Variable Types
• Where to Use Parameters and Variables
• Overriding Connection Attributes in the Parameter File
• Parameter File Sections
• Null Values
• Sample Parameter File
• Entering a Parameter File in the Workflow Properties
• Entering a Parameter File in the Session Properties
• Using Variables to Specify Session Parameter Files
• Using a Parameter File with pmcmd
• Parameter File Example
• Guidelines for Creating Parameter Files
• Troubleshooting Parameters and Parameter Files
• Tips for Parameters and Parameter Files
• Using FastExport Overview
• Verifying the Code Page Mapping File
• Step 2. Change the Reader
• Step 3. Change the Source Connection
• Step 4. Override the Control File (Optional)
• Rules and Guidelines for Using FastExport
• Before You Begin
• Loading Data to a Named Pipe
• Staging Data to a Flat File
• Partitioning Sessions with External Loaders
• Processing LOB Data
• IBM DB2 EEE External Loader
• Rules and Guidelines for IBM DB2 EEE External Loaders
• Setting Operation Modes
• Configuring Authorities, Privileges, and Permissions
• Loading Blank Spaces using the IBM DB2 EE External Loader
• IBM DB2 EE External Loader Return Codes
• Configuring IBM DB2 EEE External Loader Attributes
• Rules and Guidelines for Oracle External Loaders
• Loading Multibyte Data to Oracle
• Configuring Oracle External Loader Attributes
• Rules and Guidelines for Sybase IQ External Loaders
• Delimited Flat File Targets
• Fixed-Width Flat File Targets
• Configuring Sybase IQ External Loader Attributes
• Rules and Guidelines for Teradata External Loaders
• Overriding the Control File
• Configuring Teradata MultiLoad External Loader Attributes
• Configuring Teradata TPump External Loader Attributes
• Configuring Teradata FastLoad External Loader Attributes
• Configuring a Session to Write to a File
• Configuring File Properties
• Selecting an External Loader Connection
• Troubleshooting External Loading
• Rules and Guidelines for Using FTP
• Using FTP with Source Files
• Using FTP with Target Files
• Configuring SFTP in a Session
• Selecting an FTP Connection
• Configuring Source File Properties
• Partitioning FTP File Targets
• Session Caches Overview
• Cache Memory
• Naming Convention for Cache Files
• Cache File Directory
• Calculating the Cache Size
• Auto Cache Size
• Configuring a Numeric Cache Size
• Steps to Configure the Cache Size
• Configuring the Cache Size for Cache Partitioning
• Incremental Aggregation
• Configuring the Cache Sizes for an Aggregator Transformation
• Troubleshooting Aggregator Caches
• 1:n Partitioning
• n:n Partitioning
• Configuring the Cache Sizes for a Joiner Transformation
• Troubleshooting Joiner Caches
• Sharing Caches
• Configuring the Cache Sizes for a Lookup Transformation
• Configuring the Cache Sizes for a Rank Transformation
• Configuring the Cache Size for a Sorter Transformation
• Configuring the Cache Size for an XML Target
• Optimizing the Cache Size
• Incremental Aggregation Overview
• Integration Service Processing for Incremental Aggregation
• Reinitializing the Aggregate Files
• Finding Index and Data Files
• Partitioning Guidelines with Incremental Aggregation
• Configuring the Mapping
• Configuring the Session
• Session Log Interface Overview
• The Integration Service and the Session Log Interface
• Rules and Guidelines for Implementing the Session Log Interface
• INFA_InitSessionLog
• INFA_OutputSessionLogMsg
• INFA_OutputSessionLogFatalMsg
• INFA_EndSessionLog
• INFA_AbnormalSessionTermination
• Building the Library in UNIX
• Building the Library in Windows
• Using the External Session Log Library
• Understanding Buffer Memory Overview
• Using Session Configuration Objects for Memory Configuration
• Configuring Buffer Memory
• Session Cache Limits
• Configuring Automatic Memory Settings for Session Caches
• High Precision Data Overview

• Pre-worklet variable assignment. Update user-defined worklet variables with the values of parent workflow or worklet variables or the values of mapping variables from other tasks in the workflow or parent worklet that run before this worklet.
• Post-worklet variable assignment. Update parent workflow and worklet variables with the values of user-defined worklet variables.
• Edit the worklet for which you want to assign variables.
• Click the Variables tab.
• Pre-worklet variable assignment. Assign values to user-defined worklet variables before a worklet runs.
• Post-worklet variable assignment. Assign values to parent workflow and worklet variables after a worklet completes.
• Click the edit button in the variable assignment field.
• In the pre- or post-worklet variable assignment area, click the add button to add a variable assignment statement.
• Click the open button in the User-Defined Worklet Variables and Parent Workflow/Worklet Variables fields to select the variables whose values you wish to read or assign. For pre-worklet variable assignment, you may enter parameter and variable names into these fields. The Workflow Manager does not validate parameter and variable names. The Workflow Manager assigns values from the right side of the assignment statement to variables on the left side of the statement. So, if the variable assignment statement is “$$SiteURL_WFVar=$$SiteURL_WkltVar,” the Workflow Manager assigns the value of $$SiteURL_WkltVar to $$SiteURL_WFVar.
• Repeat steps Configuring Variable Assignments to 6 to add more variable assignment statements. To delete a variable assignment statement, click one of the fields in the assignment statement, and click the cut button.

Are you sure you want to delete the comment?

Confirm Rejection

Enter the reason for rejecting the comment.

Are you sure to delete your comment?