Ustring in Schema File
Posted: Mon Mar 14, 2011 1:52 pm
Hi,
I am trying to Restructure data from a File through Column Import Stage.In Column Import Stage, have assinged Schema File with RCP enabled.
Since I am expecting Special characters in the File, so I set 'Ustring' in Schema file.
Say, when I mentioned ustring max[5] in schema file and if get data of 7 Bytes but with character length of 5 only, I am expecting the same rejected through Column Import Stage (I mentioned a reject link to Column Import Stage).
But schema file is being validated based on Character length instead of Byte size and records are getting parsed thru it.
Does schema file validation happens on Byte size when I specify datatype as Ustring or still it will consider the normal length only?
Thanks,
I am trying to Restructure data from a File through Column Import Stage.In Column Import Stage, have assinged Schema File with RCP enabled.
Since I am expecting Special characters in the File, so I set 'Ustring' in Schema file.
Say, when I mentioned ustring max[5] in schema file and if get data of 7 Bytes but with character length of 5 only, I am expecting the same rejected through Column Import Stage (I mentioned a reject link to Column Import Stage).
But schema file is being validated based on Character length instead of Byte size and records are getting parsed thru it.
Does schema file validation happens on Byte size when I specify datatype as Ustring or still it will consider the normal length only?
Thanks,