I am trying to do "View Data" from a sequential file stage and it tells me an error saying Data Source is empty. But actually the data file is having data.
Does anyone had the same problem before?
Thanks
Venkatesh
Error - Data Source is empty!
Moderators: chulett, rschirm, roy
Data source empty is not an "error". If your metadata is bad, then DS may have trouble parsing the file and because your metadata says throw away any bad rows, you end up with an "empty" file, which just means none of the rows were usable.
Here's a good suggestion: Take your sequential source file and do a "head -n10 yourfile> smaller_yourfile" and use that in your Sequential stage. Experiment with the metadata until you figure out what's wrong with your metadata. You could have a wrong delimiter, quote characters, column definitions, etc. Once that's able to view data, then switch back to the big file.
Here's a good suggestion: Take your sequential source file and do a "head -n10 yourfile> smaller_yourfile" and use that in your Sequential stage. Experiment with the metadata until you figure out what's wrong with your metadata. You could have a wrong delimiter, quote characters, column definitions, etc. Once that's able to view data, then switch back to the big file.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle