Showing an extra record/line

srivsn · #1 (**permalink**) 05-04-2006

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

zazzybob · #2 (**permalink**) 05-06-2006

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
AWK - if last line/record do something	PacificWonder	Shell Programming and Scripting	3	06-05-2008 11:13 PM
how to insert a extra line in a text file	bhaviknp	Shell Programming and Scripting	2	03-07-2008 08:38 AM
Finding a character in first line of a record	bsandeep_80	Shell Programming and Scripting	14	07-26-2007 11:04 AM
Showing extra line/record in file	srivsn	Shell Programming and Scripting	1	05-04-2006 09:35 AM
how to extract last line in record	bjorb	Shell Programming and Scripting	7	10-18-2005 02:12 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by