Showing extra line/record in file

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

Hello everybody,

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 how to check that extra line with solution as I am new to this.

Thanks and regards,
Srivsn

ranj@chn · #2 (**permalink**) 05-04-2006

It could be just a newline after the last record which is giving you this count.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to read record by record from a file in unix	raoscb	UNIX for Dummies Questions & Answers	1	05-16-2008 06:30 AM
how to insert a extra line in a text file	bhaviknp	Shell Programming and Scripting	2	03-07-2008 08:38 AM
Script to search a bad record in a file then put the record in the bad file	shilendrajadon	Shell Programming and Scripting	2	12-28-2007 10:02 AM
splitting a record and adding a record to a file	rsolap	Shell Programming and Scripting	1	08-13-2007 01:58 PM
Showing an extra record/line	srivsn	Filesystems, Disks and Memory	1	05-06-2006 09:35 AM

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


	Powered by