Reading multiple file from unix server and dumping all the rows into a table in oracle

[Anonymous]

Hi All,

i am trying to design a job where i am retrieving the files from a unix server and need to dump all the rows into a table in oracle.

attached is the screenshot of the error that i am getting. i.e. the tfileinputdelimited is unable to find the path(global variable) of the tfilelist component.

Kindly help.

Thanks

[Anonymous]

Are you running from localhost? If the server is remote you'll need to deploy to that server (i.e. the file system paths defined in your job represent the file system paths of wherever the job is running from)

[cterenzi]

That is not a tFileList component; it's a tFTPFileList. You'll need a tFTPGet to retrieve the file before you can operate on it.

[Anonymous]

Hello,

So far, talend don't support for transferring data by air.

You have to save your files from unix server to local machine(tFTPGet component) firstly and then load all the rows into oracle table.

Best regards

Sabrina

[Anonymous]

thank you. will apply this one and will get back to you in case I face any issue

[Anonymous]

Hi,

Feel free to post your issue here.

Best regards

Sabrina