I am creating a job, where the Input is a File with 2 columns
Column1: String (5)
Column2 : String (2)
I have some transformation function to be applied on these columns & load into a Output file:
Column1: String (3)
Column2: String (1)
How to abort this job when a length of a column exceeds/subceeds the specified length of a input compoment without having to use the Length function & check the length.
tFileInputDelimited --> tMap --> tFileOutputDelimited
you can check the length of column in tmap itself, and take two output.
1) check the length of the column to the expected value then populate to output delimitted.
2) check the lenght of the column is less than then populate to tDie.
Thanks, I am aware of this method. But I wanted to know if there is any other method without checking the length & aborting the job, like a option enabled in either tMap or tFileOutputDelimited component in restricting records if it doesnt fall in the appropriate length by aborting the job automatically.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables