How to loading flat file from configuration in Talend

Question

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?

Answer 1

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.