top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Specifying Source file name using parameter variables in informatica 9?

+3 votes
1,635 views

I have a mapping like
SA-->SQ--->EXPR--->TGT

The source will be of the same structure and the tartget also.
There are a bunch of files(with the same structure) which will go through this mapping .
So i want to use a parameter file through which i will give the file names for every run manually.

How to use the param file in session for Source filename attribute
Please suggest..

posted Mar 13, 2014 by Rohini Agarwal

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

2 Answers

0 votes

You can use indirect source type, wherein your source file is basically a list of files, and in turn the session reads each of the files one by one.

The parameter file could reference a source file name (the list) as :

$InputFile_myName=/a/b/c.list

answer Mar 13, 2014 by Shweta Singh
0 votes

As I understood, you want to load the file one by one. As structure is same so you can parametrize the name and before every run you can pass the file name through parameter file.
You just need to take two parameter one for path and another for file name like - $$PATH & $$FILE_NAME.

answer Apr 25, 2014 by Shatark Bajpai
Similar Questions
+1 vote
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 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.

+2 votes
Error while reading source file name starts with a number in informatica

The source file name in my project starts with a number for example 20070908abcd.csv. Informatica is not allowing to read the source in the designer and displays the following message:
The first character in this name cannot be a number.

Could you please let me know how to handle as many source files are of this format?

+1 vote
How to specify Row Delimeter while writing to file in informatica 9

I have data with only 1 column and about 50 rows in it like

col
-----------
ab~~8900~~iop
nmk~~?~~ioiooo
king~~till~~8899089

the data will have column delimeters(i.e~~) but i will not seperate them. I have to clean the data and write to file after cleaning But the output file should be like

 col
 ------
 ab~~8900~~iop#^#nmk~~?~~ioiooo#^#king~~till~~8899089
The row delimeter here is #^#

How can i get this done.

Please suggest.

0 votes
Informatica issue - Parameter file

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.

...