Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-05-26 05:48 AM

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)

Labels (3)
Labels
295 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2018-05-26 09:49 AM
Author

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

295 Views
0 Likes
Anonymous
Not applicable
‎2018-05-26 10:46 AM
Author

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 
295 Views
0 Likes