Sequential file

mayura · Post by **mayura** » Tue Apr 27, 2010 5:01 am

Sequential file has 10 records.Delimeter is comma separated.
when i was trying to view it via job,It is showing me only one record instead of 10 while in unix i can able to see all the records.

Please solve this !!

nani0907 · Post by **nani0907** » Tue Apr 27, 2010 5:10 am

the problem may be that you might have not defined the coulms corectly and also check the first line is column name as true if you have header record for your file

mayura · Post by **mayura** » Tue Apr 27, 2010 5:37 am

nani0907 wrote:the problem may be that you might have not defined the coulms corectly and also check the first line is column name as true if you have header record for your file

Actually i have defined all the column names correctly and the condition for firt line should column name is true.

sathya_anjan · Post by **sathya_anjan** » Tue Apr 27, 2010 5:38 am

When you click on View data in the Sequential file, you will get a "Data Browser" Pop up. Make sure the "Rows to Display" is not 1 and 10 (since your record count is 10). If it is set to 1, you will always see 1 record irrespective of Record Count in the sequential file.

If you have the above setting set to 10 rows then you need to let us know how you have configured Sequential File.

mayura · Post by **mayura** » Tue Apr 27, 2010 5:39 am

sathya_anjan wrote:When you click on View data in the Sequential file, you will get a "Data Browser" Pop up. Make sure the "Rows to Display" is not 1 and 10 (since your record count is 10). If it is set to 1, you will always see 1 record irrespective of Record Count in the sequential file.

If you have the above setting set to 10 rows then you need to let us know how you have configured Sequential File.

All settings are correct only ...

chulett · Post by **chulett** » Tue Apr 27, 2010 5:42 am

No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps.

sathya_anjan · Post by **sathya_anjan** » Tue Apr 27, 2010 5:44 am

Please provide further details on how you have configured Sequential File. Unless you stop your 1 liners and provide details you will never get any resolution.

mayura · Post by **mayura** » Tue Apr 27, 2010 5:45 am

chulett wrote:No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps. ...

Problem got solve actually the view data period was set to 11 now i have changed it to 1 now i am able to see the records..

nani0907 · Post by **nani0907** » Tue Apr 27, 2010 5:46 am

What are the feild defaults and final delimetrs option given in that satge?

mayura · Post by **mayura** » Tue Apr 27, 2010 5:47 am

nani0907 wrote:What are the feild defaults and final delimetrs option given in that satge?

hey problem solve no worry !!!
view data period was set to 11 i have make it as 1

chulett · Post by **chulett** » Tue Apr 27, 2010 5:47 am

mayura wrote:
chulett wrote:No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps. ...
Problem got solve actually the view data period was set to 11 now i have changed it to 1 now i am able to see the records..

Or that.

nani0907 · Post by **nani0907** » Tue Apr 27, 2010 5:48 am

sathya_anjan · Post by **sathya_anjan** » Tue Apr 27, 2010 5:49 am

Like I predicted it was the "Data Browser" property. Please look in twice before you say "All is Well".

Anyways, please click on the Button at the top of the Post to Mark it Resolved.

chulett · Post by **chulett** » Tue Apr 27, 2010 5:51 am

Please look twice before asking someone to mark something Resolved - they already had when you posted.

sathya_anjan · Post by **sathya_anjan** » Tue Apr 27, 2010 5:53 am

When I sent in the message, it was still not Marked as Resolved.

But now it is!! :D