Problem with Fixed width Input File (tFileInputPositional)
Hi, I am supposed to read a fixed width input file and I am doing so with the tFileInputPositional component. The length of this file's first column is 15. For one row of data, the first column in the input file is of length 12. This is obviously a wrong record. When this record is passed to the output file, the first column takes the first 3 characters of the 2nd column (to adhere to length 15) that makes the output completely wrong. I want to know how can I reject this record or make changes in the job in such a way that the output comes correctly. For the same input file in DataStage, this particular record was getting rejected from the input stage (Sequential FileStage) itself. Below is the screen shot of the o/p data :
