I have built a generic job which loads fixed width files to appropriate tables, by parameterizing the files positional info and the table name using the dynamic option in
tfileinputpositional and tDBoutput, component but sometimes the file may contain characters which are larger than the expected number of characters, in that case I want to reject those records, I'm not finding any option find the length of all dynamic column characters, is there any way to achieve this?
first step you can do is, pass length of record as parameter from parent job and in child job first reject all the records greater than len of rec using filter component and good record load in DB.
