I am loading data into tables using SQL Loader. My datavaires from being comma delimited to simply using whitespace.
The problem is that vendors will often decide to add or remove a column without notification. Is there a way to have the loader check the number of fields then either break if it's incorrect or load the data if it is correct?
Any help you can provide will be greatly appreciated