Page 2 of 2
Posted: Tue Nov 24, 2009 6:30 am
by chulett
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.
Posted: Tue Nov 24, 2009 9:56 pm
by deepa_shenoy
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
Posted: Tue Nov 24, 2009 10:09 pm
by chulett
Metadata mismatch.
Posted: Tue Nov 24, 2009 10:40 pm
by deepa_shenoy
But for the same metadata, it passes 7 lac records, and rejects only 280 records.
Posted: Tue Nov 24, 2009 10:43 pm
by chulett
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.
Posted: Wed Nov 25, 2009 11:22 pm
by deepa_shenoy
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