How to loading flat file from configuration in Talend

0 votes
Hello All, I am beginner of Talend. I have the project to loading many type of file to database. My purpose here is, I have one configuration table include(Source path, destination path, done path, error path, insert to destination table name...). If I want to load flat file to table. I just add information of file or table name into this table then create job and set schedule for running.

How Talend can do this?
Jun 3, 2020 in Talend by Edureka
• 140 points
1,756 views

1 answer to this question.

0 votes

Hey, @There,

Regarding your query you need to follow few steps given below:

  • Create a job
  • Give a name to it  like "flatfiletodatabse"
  • Then click on finish
  • Go to metadata where the flat file will be present which u want to load, drag that to the job.
  • select tfile delimited and click ok.
  • Now you require oracle output, for that click over the palette and search for tOracleOutput and drag that to your job.
  • Now connect the link between the source and target ie your falt file and tOracleOutput.
  • Now to set the properties of both source and destination, click on the flat file and see the path has given correctly and row separator should be within inverted commas like "\n".
  • Now to set the properties of destination that is tOracleOutput, double click on the file and click on the host and add localhost, add port to 1521, add the database to orcl, add username and password according to you then click ok. 
  • Add action on table= "create table if it does not exist". and action on data should be inserted.
  • Then save the job and run the job.

You will be able to see the number of records in your file and you can even cross-check it.

I hope this will be helpful.

To know more about Talend, join Talend for big data certification training today.

Thanks.

answered Jun 4, 2020 by Gitika
• 65,910 points

Related Questions In Talend

0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
7,252 views
0 votes
1 answer
0 votes
2 answers

How to use java classes in Talend?

For many data integration requirements, the standard ...READ MORE

answered Oct 3, 2018 in Talend by daisyridley
• 160 points

edited Oct 3, 2018 by Vardhan 2,849 views
0 votes
1 answer

In Talend, how to specify multiple conditions as expression

@Palaniswamy, have a look at this discussion ...READ MORE

answered Aug 5, 2019 in Talend by Vardhan
• 13,190 points
6,310 views
0 votes
0 answers

How can I use talend to extract data from Oracle and import the data into a MSSQL database?

We currently have around 100 Oracle tables ...READ MORE

Nov 4, 2020 in Talend by umesh
• 150 points
2,157 views
0 votes
0 answers

how to read .dbf files in talend 2020 ?

hi , i am new in talend ...READ MORE

Dec 2, 2020 in Talend by aminegac
• 570 points
1,426 views
0 votes
2 answers
0 votes
2 answers

Read Data from Rest API's through Talend and store it in Oracle

Hi, @Abhishek, Regarding your query, I would suggest ...READ MORE

answered Oct 15, 2020 in Talend by Gitika
• 65,910 points
2,752 views
0 votes
1 answer

how to add data to existing file and how to use LIST properly ??

Hi, @Aminegac yes, in the output file there's ...READ MORE

answered Dec 4, 2020 in Talend by Gitika
• 65,910 points
1,393 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP