topic how to load the data fram a csv file to staging table. in Talend Studio

how to load the data fram a csv file to staging table.

Anonymous — Sat, 16 Nov 2024 08:12:44 GMT

am very new to talend.. can anybody help me in loading data fram a csv file to staging table(oracle)

Re: how to load the data fram a csv file to staging table.

Anonymous — Sat, 26 May 2018 13:49:29 GMT

Hello Sindhu,

For loading data from CSV to ORACLE you will need 2 Talend Components:
1. tFileInputDelimited
2. tOracleOutput

Steps :
First drag tFileInputDelimited component, double click on the component and give the path of your CSV file.
There are various options available for loading the CSV.
After that drag tOracleOutput compoonent. Double click and fill all the connection details.
Then attach the tFileInputDelimited to the tOracleOutput component and simply run the job

Thanks,

Trupti

Re: how to load the data fram a csv file to staging table.

Anonymous — Sat, 26 May 2018 14:46:21 GMT

Hello Sindhu..

follow this Steps:-

. go on metadata panel
select file type which u want to like tfileDelimated, file excel
drag and drop selected file in designer window
go on palette window and search tOracleoutput component and drag and drop into in designer window
join tFileInputDelimited to tOracleoutput and sync columns in to tOracleoutput
and then press f6