top button
Flag Notify
Site Registration

Update informatica session properties using unix

0 votes
377 views

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?

posted Sep 10, 2014 by Sachin

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

1 Answer

0 votes

One usually doesn't modify or even create informatica mappings/sessions/workflows using simple unix tools. If you need to modify certain parameters, you better use parameter files, which you can modify using the standard unix tools or even create dynamically using Informatica.

answer Sep 12, 2014 by Shweta Singh
Similar Questions
+1 vote

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt

I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from there i can do my logic but my question is

how can i dynamically give the flat file name in Source file name property of session.

0 votes

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.

+1 vote

Is it possible to update partial data (primary key + just one or more columns) in a matching target row while leaving others intact in target as shown below or do I have to do a lookup and port all the columns?

enter image description here

+2 votes

How can we update a record in target table without using Update strategy?

...