Read_delimited()- Required Column Missing
Moderators: chulett, rschirm, roy
Read_delimited()- Required Column Missing
Untitled1..Sequential_File_5.DSLink6: read_delimited() - row 5, column Field015, required column missing
I am getting this error while loading from sequential file to Oracle table.
Could you please let me know which is the best way to solve this issue.
Shilpa.
I am getting this error while loading from sequential file to Oracle table.
Could you please let me know which is the best way to solve this issue.
Shilpa.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Before we do that, please summarize what information you have actually gotten from the message.
For example, I can discern that you get this message using View Data when still designing the job. I can discern much more. But we need to know how good your diagnostic skills are.
Philosophy Corner
If you give a man a fish you assuage his hunger for a day. If you teach a man to fish, that is a more permanent solution.
For example, I can discern that you get this message using View Data when still designing the job. I can discern much more. But we need to know how good your diagnostic skills are.
Philosophy Corner
If you give a man a fish you assuage his hunger for a day. If you teach a man to fish, that is a more permanent solution.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't seem to have gotten much out of the message.
Which line in the file should you be looking at?
What should you be looking for it there?
How is NULL represented in this file?
What property of the link should you be changing to address this issue (the issue of missing column)?
Which line in the file should you be looking at?
What should you be looking for it there?
How is NULL represented in this file?
What property of the link should you be changing to address this issue (the issue of missing column)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Basically the problem is the first record has 16columns , the second record has 12 columns the last four colums of the second record need to be loaded as empty.However there are no pipes delimiting these empty fields.And there is also no row delimeted.
My question is how do you import the data with variable columns, if seq.file stage is not the correct one then what should be used.
I tried using a folder stage it doesnot work.
For eg:
1 record:470E|Hyd! 3721|Hyd! Consolidated||Intl||Asia Pacific||North Asia||Total China w/ JV||Total China||470E|Hyd! 3721
2 record:470E|Hyd! 3721|Hyd! Consolidated||Intl||Asia Pacific||North Asia||Total China w/ JV
Shilpa.
My question is how do you import the data with variable columns, if seq.file stage is not the correct one then what should be used.
I tried using a folder stage it doesnot work.
For eg:
1 record:470E|Hyd! 3721|Hyd! Consolidated||Intl||Asia Pacific||North Asia||Total China w/ JV||Total China||470E|Hyd! 3721
2 record:470E|Hyd! 3721|Hyd! Consolidated||Intl||Asia Pacific||North Asia||Total China w/ JV
Shilpa.
Last edited by shilpa79 on Thu Nov 02, 2006 3:27 pm, edited 1 time in total.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
two things you can do --shilpa79 wrote: My question is how do you import the data with variable columns, if seq.file stage is not the correct one
Shilpa.
1. Import this file in Access and Export it back in a new file with whatever delimiter you want.
2. Or try to use it as a fixed length file. Reading the Rows as a single row and single column.
But the question that arises is if the columns are variable how are you going to define the mapping in the next stages?? The program has to be intelligent enough to do that for you.