Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.