top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
1,040 views

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.

posted Jan 23, 2015 by Amit Sharma

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

1 Answer

0 votes

One way to do this is to use indirect sources. You can configure your session to use indirect sources, wherein the source file names are coming from a text file (each entry in the listfile is a source file session will read).

Then you can arrange your code to add that dynamic filename to that listfile.

answer Jan 30, 2015 by Shweta Singh
Similar Questions
+2 votes

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?

+3 votes

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..

...