Hi banu,
Generally speaking, you can obtain the following benefits using ETL tool than hard coding:
1. ETL tool allows you to quickly develop project to reduce development time and improve development efficiency.
2. Mature ETL tool can ensure product performance and practicality, as it has been through a lot of testing by the users around the world, has been updated and improved all the time.
3. ETL tool is usually GUI based, and it is more easy to use, not all members in a team has rich development experience, to learn a ETL tool is easier than learning a development language.
4. More connectors are available for integrating with different data sources, such file, database, sap, salesforce, FTP etc, you can achieve a ETL process quickly with ETL tool, for example, read data from a text file and insert them into Vertica database.
tFileInputDelimited--main--tVerticaOutput
However, it will take you more time if you hard code to achieve it.
i can't run multiple instance of same job but where in case of code we can run multiple threads of single job . |
I don't understand why you can't run multiple instance of same job?
And in case if i have created a job to accept file with defined number of columns , but in case the source file comes with header and less than the fields defined in the job the tool throws an error ,but in coding we can use "AWK" to handle it . |
You can use tLogCatcher to capture the error and log them to a file or database, Talend aslo supports for transaction management, commit the changes if there is no error at the end of job or rollback the changes if there has an error during the job execution.
Shong