Field with 'delim=end' did not consume entire input

chulett · Post by **chulett** » Tue Nov 24, 2009 6:30 am

Let's try the hex dump again. Unfortunately, Ray got exactly what he asked for, but what we really need are a sample of the results of this: od -hc filename - the 'h' gets us the 'hex' part along with the 'c'haracter information.

deepa_shenoy · Post by **deepa_shenoy** » Tue Nov 24, 2009 9:56 pm

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

chulett · Post by **chulett** » Tue Nov 24, 2009 10:09 pm

Metadata mismatch.

deepa_shenoy · Post by **deepa_shenoy** » Tue Nov 24, 2009 10:40 pm

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

chulett · Post by **chulett** » Tue Nov 24, 2009 10:43 pm

Metadata mismatch. You need to look at those 280 records and see what it doesn't like about them, what data does not match the metadata in the stage.

deepa_shenoy · Post by **deepa_shenoy** » Wed Nov 25, 2009 11:22 pm

Hi All,

Firstly I would like to thank everyone for their contribution and help.

I finally got the solution. PHEW!

The field delimiter -Quote=double was given.

Within the data, in some record or the other, double quotes were present. Due to this, DataStage was rejecting the records.

I changed the value of Quote and it works fine

Regards,
Deepa