[resolved] insert file name and job_id to the columns in a target table

[Viswa560]

Hi,
My Requirement is i need to insert the File_name which i am loading and job_id into columns in the target table.

Any help how to do this is help full.

Thanks 
Viswanatha Challa 

[TRF]

Hi,
My requirement is that you give us a little more detail.
Which component are do you use?

Regards,
TRF

[Viswa560]

Hi,
I am loading data from one flat file (tFileInputDelimited_3) to Oracle Data base, where i have a file name column and i need to load the current file name into that column.

[TRF · Accepted solution]

Filename of tFileInputDelimited is not accessible from any global variable.

Use tFileList before to read the file, giving something like:


tFileList:


tFileInputDelimited:


tMap:


and finally, the result:


Hope this helps.
TRF

[Viswa560]

Thanks that works