DSXchange

Iam having problems in reading a CSV file in the required format,the target columns are calculated based on the fileds in the flat file,the problem is iam using a mod and NROWNUM condition to read the data which has 1 rec split across 5 lines but my file has 1 rec split over different lines sumtimes 3 and sumtimes 4 ,the only way we can identify the start of a record which is definite ,is thr any way to load my CSV file into target table with all the recs being read and written in the target table.

Welcome aboard. :D

Get "them" to send you a valid CSV file. The CSV rules stipulate the same number of fields in each row.

If you can't get that, read each row as a single VarChar and parse it yourself, perhaps in a Transformer stage, perhaps in a Column Import stage.