Four Stars

Take 3 sample input xml files with same schema. (Like Id, Name, and Address) I want to load all files data into Database.

 

 

Note: Use only single job to load data not like as like for file1 one job and file2 another.

All implementation should be in only one job.

1 REPLY
Eleven Stars

Re: Take 3 sample input xml files with same schema. (Like Id, Name, and Address) I want to load all files data into Database.

This is a basic Talend use case. All you need to do is pass a different file name to the job or get the job to pick up all relevant files (using a tFileList component, for example). Have you built a job that can this for one of your files already? If so, to make it work with any file will not be terribly difficult. If you haven't, take a look at this (https://help.talend.com/reader/MjIZDoU6r0vLbCpGh5GAcg/Pc9RZi6IiWw1Kb~Jf0bE0Q) and see if you can extrapolate from there to build your basic job. Once you have that, then start looking into how to make it work with ANY file (with the same schema).

Rilhia Solutions