Informatica issue - Parameter file

informatica-powercenter informatica
user1173496 picture user1173496 · Feb 15, 2012 · Viewed 23.3k times · Source

My source is dat file. Intially in designer I can I import the file from my local. But later it gonna to come in shared location and Informatica need to pick it from there. I guess, for this I need to put parameter value 'Source file Directory' = '$PMSourceFileDir\' at session level in Workflow Manager. Now where is this Parameter file located? How can I get it to edit it so that I can put my parameter value also. Informatica is installed in my local but I am connecting to the repository of remote. Is there any other way so that Informatica can pick this dat file from a remote location. Please help.

Answer

Rajesh Chamarthi picture Rajesh Chamarthi · Feb 16, 2012

$PMSourceFileDir is usually set as part of the Informatica server initialization, since it is a server variable. If you want to override it for your workflow, you can do so in a parameter file.

In your workflow monitor, go to the workflow designer tab, open your workflow.

Go to Workflow > Edit > Properties > Parameter file Name.

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

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 …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More