I want to create a mapping which fetch the data from table and
generate a new file for every session run. and the name of flat file
is like 'EMP_20120101125040.dat'

Whenever the session runs you need to create a new file dynamically
and load the source data into that file.

Here issue is that I am able to create flat file like
EMP_20120101125040.dat.
but no data i populated into the file

I have attached .XML file for your reference


Below are the Step to create the mapping

STEP1: Connect the source qualifier to an expression transformation.
In the expression transformation create an output port (call it as
File_Name) and assign the expression as 'EMP_'||to_char(sessstarttime,
'YYYYMMDDHH24:MISS')||'.dat'

STPE2: Now connect the expression transformation to the target and
connect eh File_Name port of expression transformation to the FileName
port of the target file definition.

STEP3: Create a workflow and run the workflow.

Tell me the solution or what is the issue with my mapping