Sequential file
Moderators: chulett, rschirm, roy
Sequential file
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 !!
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 !!
Mayura
Actually i have defined all the column names correctly and the condition for firt line should column name is true.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
Mayura
-
- Participant
- Posts: 20
- Joined: Tue Feb 02, 2010 4:49 am
- Location: United Kingdom
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.
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 ...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.
Mayura
-
- Participant
- Posts: 20
- Joined: Tue Feb 02, 2010 4:49 am
- Location: United Kingdom
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..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. ...
Mayura
Or that.mayura wrote: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..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. ...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 20
- Joined: Tue Feb 02, 2010 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 20
- Joined: Tue Feb 02, 2010 4:49 am
- Location: United Kingdom