Validate CSV headers in Talend.

File processing is a day to day task in ETL world, and there is huge need of validation regarding source file format, headers, footers, column name, data type and so on, thanks to tSchemaComplianceCheck component which can do most of the validation like. Length checking. Date pattern/format. Data Types But does not support number of […]

Create File Name with Date and TimeStamp

This post I will describe you how to name a file with Timestamps in Talend. File name format depends upon your business requirement, for example your business requirement is to name file with time stamp like “Order_yyyyMMdd_hhmmss.dat” so it will have time stamp up to seconds hence you want to get the same file for […]

Read XML with Optional Elements

This post I will describe how to parse XML with optional element. We will use below source xml file which has three customer details, along with awards details, and <CUSTOMERAWARDS> is a optional xml element. We will parse this file using tXMLMap component. so fist of all add tFileInputXML and configure as below. Assign source […]

Page 3 of 41234