How to handle Dynamic flat file as a source in informatica

How to load the data from a dynamic flat file into the target where the source flat file name changes daily wit the file name with time stamp(ex:person_delta_020214) ?

Ans: we can archive this by using the session parameter concept.

step 1: Create Parameter File: 

dynamic_file_name.param

[FolderName.SessionName]


$InputFileName=person_delta_020214.dat

Step 2 :Specify the Parameters at Session level

go to the session and Edit the session then go to the Mapping tab. In the mapping tab, select the source qualifier in the Sources folder and set the file property "Source FileName" as $InputFileName.

Step 3 : Specifying Parameter File Name

you can specify the parameter file name at session level properties or workflow level with the parameter file name as dynamic_file_name.param

Step 4 : Update the parameter file daily :

create a new mapping to update the parameter value.

in expression create two variable ports one as variable port  
 v_1 :sysdate, 
 v_2:to_date(v_1,'mm/dd/yyyy)
o/p port o_name: concat(person_delta_,v2)

and connect  the o_name to target flat file.

the mapping should run every day before the actual mapping run, so that it will update the parameter file daily.