unix command to verify the port is enabled/opened at database end for the informatica host name

step1 : connect to informatica host  through secureshell

step2: give your username/password

step 3: [username@hostname ~]$ nc -vz hostname portno

ex:  [eswar@infor-stag-abc9-123 ~]$ nc -vz infor-stage-abc9-123 7754

press enter it will give the below message.


Connection to hostname port [tcp/databasename] succeeded!

if the port is not enable at database level for informatica host then u wont get any message. i.e it will hang.

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.