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 in Talend by Edureka
• 140 points
101 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.

answered Jun 3 by Gitika
• 36,530 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,470 points
3,003 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 1,038 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,180 points
1,415 views
0 votes
2 answers
0 votes
1 answer
0 votes
1 answer

Using tHiveRow to execute multiple Hive queries in Talend

In order to execute multiple queries, you ...READ MORE

answered Apr 14, 2018 in Talend by misc.edu04
• 1,430 points
1,488 views
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,470 points
1,649 views
0 votes
1 answer