top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Using Workflow Variables in Session Properties

0 votes
344 views

I have a scenario where my source file name will be coming from one db table I have to read that value and pass it in the value of Source File Name in Session properties.

Till now I have tried like I have created 2 sessions where the 1st session will read the db table where the source file name is stored and store it in one mapping variable and in post success variable assignment I am assigning the mapping variable value to workflow variable and in the next main session I am trying to give the workflow variable in the session file name attribute .

But it is showing error like below

fail to expand variables in file field [$$WL_File].

How can I achieve this.

Please suggest some ideas.

posted Sep 3, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In Target definition, on Columns tab you can click the "Add FileName column to this table". Then in the mapping whatever you'll pass to this port will be used as the file name, instead of the file name defined in session properties. Creating multiple output files is a bit more tricky and will require Transaction Control to tell when one file is completed

answer Sep 8, 2014 by Shweta Singh
Similar Questions
0 votes

I want to maintain audit information of each and every mapping in table which contains

workflow_name | start_time | end_time | source_success_rows | target_success_rows | error_record_count

i am able to do it using workflow variables assigning them with built-in session variables and then using the property of prevariableAssignment in session assigning the workflowflow variables to mapping variables of audit_session

It is working fine , But the issue is if i want to maintain audit for other mapping i have to create the whole process again . So is there any possibility of automating the process so that it does not require recreation of the whole thing again.

0 votes

I have requirement where I will create a mapping manually and I will use unix to create task and workflow and update sessions properties with some default values.
How to do that?

+2 votes

How do you include you mapping output variables in the workflow without having to use a human task?

Basically I have one row of data that I want to push out and to be included in e.g. the body of the Notification task or as an attachment.

We are not using power center, only the developer tool.

+2 votes

How to tune the session, workflow for better performance, what are the things we consider for better performance?

+2 votes

I have two sessions I a workflow like below

workflow1->session1->session2

I have a join_date column in a table in Mapping1 , in session1. I want to pick this join_date value and pass to mpping2/session2

If join date value changes in the table in session1 then the same value should pick and pass to session2. I will use this date value in a query in session2 .

Please suggest how to achieve this?

...