I am trying to LOAD a table with the following TPT scripts.
1. ErrorLIMIT1 = 5
2. ErrorLIMIT2 = 5
3. Maxsessions = 1
4. Minsessions = 1
5. Loader_Instance = 1
I have a file with 10 UV Values for a single Key value e.g., for primary key = 2 there are 10 UV records. I expected TPT to fail but it did not. Can anyone explain this behavior? What is the scenario in which Errorlimit is used by TPT and it fails.
The ErrorLimit attribute applies to the number of error records during the acquisition phase.
During the acquisition phase, error records include these errors:
* Data conversion errors
* Constraint violations
* AMP configuration changes
The ErrorLimit attribute does not apply to UV records. UV records occur in the application phase.
Does this Errorlimit apply to the case when the column data type is integer and the values are coming as varchar 'a' ,'b' etc?
Yes, the ErrorLimit applies to the case when the column data type is integer and the values are coming as varchar 'a', 'b', etc.