Passing a value from the parent Job to the child Job is a common real world requirement. I am going to describe different ways of passing values from parent job to child job using following different ways. Passing context to child job. Passing globalMap to child and get the result back in parent. Get the […]
In my Last post, I have demonstrated how to Validate CSV headers using Talend. In this post we`ll see how to validate source data with output schema? for that we will use tSchemaComplianceCheck component. tSchemaComplianceCheck Validates all input rows against a reference schema or check types, nullability, length of rows against reference values. The validation can be carried […]
Difference between tAggregateRow and tAggregateSortedRow was question to me, so I started searching possible answers and I found nothing even on Talend help centre nor on Google. Therefore writing this post. This is our input for demonstration. I know these many columns not required but still wanted to use. tAggregateRow: Receives a flow and aggregates it based on […]
Scenario: Delete files more than ‘N’ number of days older, using Talend. Step 1: Create Job and add tFileList on canvas and configure as follows. Set Directory path as your files location. Select FileList Type as “Files”. Case Sensitive=”No”. Add File mask as “*.txt”. ( you can add per your file type). Step 2: Add tFileProperties […]
I will demonstrate you, how to add custom header, footer to file. This is the often required functionality for file processing and validation. Requirement: Create delimited file with below structure. Header Part File Name: Name of the actual File. PID : process ID. Header Columns. Body Part Text Data. Footer Part File Created Date: Date […]