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

One Star

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

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

Five Stars

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

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

Seven Stars

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

Hello Sindhu..

follow this Steps:-

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