Posted: Tue May 31, 2016 6:28 am
That is an interesting question indeed, but unfortunately the answer is that the extra length isn't detected or flagged with your scenario using a schema file and RCP.
Depending upon how important this is to you, there are some methods that I can think of to get this information, but they do involve quite a bit of work. You can read the data in using a dummy schema defining the columns as varchar with no length, apply an aggregator to get the maximum length and then compare that with the appropriate values in the schema file to output a flag on whether a column's length has been exceeded. It is neither simple nor efficient if you have large amounts of data.
Depending upon how important this is to you, there are some methods that I can think of to get this information, but they do involve quite a bit of work. You can read the data in using a dummy schema defining the columns as varchar with no length, apply an aggregator to get the maximum length and then compare that with the appropriate values in the schema file to output a flag on whether a column's length has been exceeded. It is neither simple nor efficient if you have large amounts of data.