Complex flatfile warning

pkll · Post by **pkll** » Thu May 21, 2015 6:53 am

HI All,

I am getting below warning message.Let me know how to resolve warning

Import consumed only 460bytes of the record's 461 bytes (no further warnings will be generated from this partition)

My source is Complex flatfile and fixed with data.

chulett · Post by **chulett** » Thu May 21, 2015 6:55 am

Your metadata doesn't match what it found in the file. Perhaps your EOR setting?

ray.wurlod · Post by **ray.wurlod** » Thu May 21, 2015 4:40 pm

Check the value of the Record Delimiter property. If this is UNIX style, change it to use the Record Delimiter String property set to DOS style.

FranklinE · Post by **FranklinE** » Fri May 22, 2015 9:15 am

We need a bit more detail. Is the source file from a mainframe system? Are you reading it natively or downloading to the local server first? What is the format of the file in either case?

CFF is designed for Cobol formatted data. The most common storage format is implied record lengths -- the "lrecl" or logical record length -- and your table definition controls everything implicitly. "Fixed width" anything is irrelevant.

Given that, I respectfully suggest that your problem is not delimiters, it's your table definition's compatibility with the file's original storage format.

pkll · Post by **pkll** » Mon May 25, 2015 7:59 am

chulett wrote:Your metadata doesn't match what it found in the file. Perhaps your EOR setting?

Yes it is working properly.....In meta data total length is 160 .but, data file length is 161 charactes.
now it is working .....

chulett · Post by **chulett** » Tue May 26, 2015 6:48 am

Now it is working... because you did what to correct it?