Unanswered posts

ViswanathaChalla

Member

8 posts

ViswanathaChalla said:

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

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

Member

388 posts

TRF said:

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

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

Regards,
TRF

ViswanathaChalla

Member

8 posts

ViswanathaChalla said:

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

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.

Last edited by ViswanathaChalla (2017-04-07 10:26:56)

TRF

Member

388 posts

TRF said:

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

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

ViswanathaChalla

Member

8 posts

ViswanathaChalla said:

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

Thanks that works