Filesystems, Disks and Memory

Hello everybody,

I am working on ETL side. My job is to load the data from Oracle table to flat file and from flat file to oracle table using ETL tool Informatica. My flat files are fixed width. In the first phase, it is loading 66351 records into data file through tool. When I checked through wc -l <data filename> it is giving 66352. I attached a QC file to check the source count. In that file it is giving correct count as 66351. When I loaded the data from this data file to table, only 66351 records are loaded. Not 66352 records. I am confused why it is giving an extra line in the file with WC command but it contains exactly the same number of rows in source. Please send all possibilities with solution as I am new to this.

Thanks and regards,
Srivsn

Is there an End-of-line character (/n) on the end of the last row?

Code:

# echo "two
lines" > /tmp/2lines
# echo "two
lines
" > /tmp/not2lines
# wc -l /tmp/{not,}2lines
2 2lines
3 not2lines
5 total

Cheers
ZB