DSXchange

Hi All,

I am having one flat file which looks like :

FUND CODE1 HDFC BANK FUND CODE HDFC FUND CODE DESCRIPTION
HOLD 1 HOLDING 1 CODE1 40 1 40 GBP
.......
.......

likewise there are no . of records in the file . there are two record type in the file FUND & HOLD. FUND record type is having 4 columns while HOLD record type is having 8 columns .Now i am trying to read this file & spliting into two seq files based on the record type. i have used CFF stage & defined everything in the stage but when i try to view data following error is coming :

:Short input record
<Complex_Flat_File_0,0> Import warning at record 0.
<Complex_Flat_File_0,0> Import unsuccessful at record 0.
<Complex_Flat_File_0,0> Import complete; 0 records imported successfully, 1 rejected.
and so on for rest of the records.

what should be done to avoid the errors....
Any help is appreciated.

First line is column headings?

You may need to suppress reading of this row if such is the case.

Thanks Ray,

No the first line is not column headings,it`s the actual data. Supressing the data mean removing the spaces between column values.
This is what you meant to say w.r.t supressing ? Ray , can we specify the delimiter in this scenario.

Then your metadata do not correspond to what's in the file, or you have not indicated in the CFF stage which field identifies the record type. With multiple record types I presume you have set up separate output links for each?