I have tired to load the data into target table having UPI using Fastload.While loading Duplicate value for UPI is captured in Error Table 2.so, Error table 2 is not dropped but fastload terminated with Return code 0.
please suggest me how to fix uniqueness violation error .
when the fastload receives duplicate values for the UPI, it inserts the UPI violation rows into error table. this error table is created each time, but dropped only if there is no UPI violations. Since you hve UPI violations, so the table will contain all the violated rows.
To avoid this unique violation error, if you have to retain duplicate values, convert the PI to NUPI, and also the Table to Mutliset.