error while viewing the data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
error while viewing the data
Hi All,
Can some what explain me what is warning iam getting while viewing the data from target file stage,,
DunsContactFileTEST..Sequential_File_3.DSLink6: read_delimited() - row 1, column length_of_S2, required column missing
DunsContactFileTEST..Sequential_File_3.DSLink6: read_delimited() - row 2, column contact_full_name, required column missing
Thank you ,
Can some what explain me what is warning iam getting while viewing the data from target file stage,,
DunsContactFileTEST..Sequential_File_3.DSLink6: read_delimited() - row 1, column length_of_S2, required column missing
DunsContactFileTEST..Sequential_File_3.DSLink6: read_delimited() - row 2, column contact_full_name, required column missing
Thank you ,
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi Anu,
Seems like your metadata is not matching the data that you are trying to read from the sequential file. Check to make sure the column names,sizes,position,type exactly match the data that you are trying to read.
Also, check the format of the sequential file you are trying to read from and depending upon the format, use the appropriate options in the Format Tab of the sequential file stage.
Seems like your metadata is not matching the data that you are trying to read from the sequential file. Check to make sure the column names,sizes,position,type exactly match the data that you are trying to read.
Also, check the format of the sequential file you are trying to read from and depending upon the format, use the appropriate options in the Format Tab of the sequential file stage.
Thanks,
Naveen
Naveen
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Thank you pnchowdary , my metadata is matching correctly , but what i did is i added few columns to target stage in the transformer by inserting new column and defined type and length of the fields and after that
i see the additional columns in the target stage also ,
is this causing problem.
Thank you all , any inputs would be greatly appreciated.
i see the additional columns in the target stage also ,
is this causing problem.
Thank you all , any inputs would be greatly appreciated.
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi NaveenD,
We have tons of jobs where we take the input as .csv file and create the ouput file in the fixed width format.
I dont think that's true. The Input file format can be different from the Target file format.the problem here is the input file format is different from the target file format
We have tons of jobs where we take the input as .csv file and create the ouput file in the fixed width format.
Thanks,
Naveen
Naveen
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Hey Dude,
Pnchowdary, I think you didn't follow what I said. The point I'm trying to make is that if the input file in reality is a fixed width and if you don't check that 'fixed width format' in the stage where you are reading that file then you get such errors.
Sorry, if my language mislead you,
Naveen.
Pnchowdary, I think you didn't follow what I said. The point I'm trying to make is that if the input file in reality is a fixed width and if you don't check that 'fixed width format' in the stage where you are reading that file then you get such errors.
Sorry, if my language mislead you,
Naveen.
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi NaveenD,
Yes, your earlier statement was misleading. However, I do agree with what you mean by it now.
I have already asked her to check the same thing in my first response
Yes, your earlier statement was misleading. However, I do agree with what you mean by it now.
I have already asked her to check the same thing in my first response
Anyway, lets wait for her to respond back and see what she comes up with.Also, check the format of the sequential file you are trying to read from and depending upon the format, use the appropriate options in the Format Tab of the sequential file stage.
Thanks,
Naveen
Naveen
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm