DSXchange

But for the same metadata, it passes 7 lac records, and rejects only 280 records.

Hi,

When a 'lc' is done on the target file, it gives the exact count.

But while reading from the file, it reads only 90% of the records.

Could the issue be something else?

Regards,
Deepa

Anyone any solution?

Thank you for that information. A portion of the hex dump is 547756620 253 " \n " L E S B " , 547756640 " 253 " , " G o o d m a n & S 547756660 o n s " , " S u l l i v a n " , 547756700 " I N " , " 4 7 8 8 2 " , " R . 54775672...

I'm sorry, but what is a 'hex dump'? I have not used any Record Schema. Also, the value I am giving to the Null Field value is '\xAB' I notice the problem is because it is the LAST column. Field Delimiter is comma. Record Delimiter is NEW UNIX Line Final Delimiter is end Quote is double. Thanks in a...

I gave Record delimiter string=DOS Format in the Formats Tab. Sample data in the file which is getting rejected is: 0472 3599 INDUSTRIES, INC. AURN WA 980 3223 STREET, NE, UNIT 6 NULL NULL NULL NULL NULL 0 NULL NULL 100 3542 PRODUCTS, INC. OHAM NE 681 126 STREET NULL NULL CHUCK ODDO 402-333 NULL 0 N...

It did not work... any other solution?

Hi All,

Does anyone have any solution??

Thanks in advance.

Regards,
Deepa

Well, I was not very sure about my approach.If it is equivalent to being resolved then great!

Finally I was able to VIEW DATA!!!

I changed the Null Field Value to '\xAB' and Quote to 'double' for each column in the Columns tab by double clicking on its serial number.

The error still persists.

I posted a new topic as the previous topic's subject line would have been misleading.

The source and target columns of the files have Varchar(1). 90% records are passed and 10% rejected. Why are the 10% getting rejected?

The error thrown is:

Sequential_File_9,0: Field "DP_Customer_Sol" with 'delim=end' did not consume entire input, at offset: 145

Yes... "Customer" is declared as Varchar(1) in the Source Seq File.

It is the last column of the source file. 90% of the records have moved to the target file from the source file. 10% are getting rejected.

But both source and target clumns are Varchar with length 1.