i get out put file frist field like #id,e_ID,pt_Status, but i dont want #

Scenario:

my source .csv stg oracle tgt .csv i get out put first field #along with columan name.
and i want to delete dummy files my server is windows

Solution:

It is not a problem.You need to provide the targetfile path and the name in the input filename and output filename you can provide the file location and the name you want to have in the target file (final file).

Ex:

Oracle_emp(source)--> SQ-->Logic-->TGT(emp.txt)(Flatfile)

In post session sucess command

sed 's/^#//g' d:\Informaticaroot\TGTfiles\ emp.txt > d:\Informaticaroot\TGTfiles\