Data Validation in ETL Using TALEND

This paper describes the methodology of a data warehouse used for analysis, validation using the flat files from various sources. A flat file is a file that stores data in plain text format. A flat file includes a record per line of a table. The columns in a record are delimited by a comma separated fields. Flat file database does not contain multiple tables. Extract Transform Load (ETL), is the process in data warehousing that deals with extracting data from different source system and placing the processed data in the data warehouse. In this paper we are going to explain about etl process, talend tool and validation of the data using talend tool.