Fastload Error Table 2

General

Fastload Error Table 2

Hi all,

 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 .

Regards,

Gowthami

2 REPLIES
Enthusiast

Re: Fastload Error Table 2

Hi,

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.

Khurram
Enthusiast

Re: Fastload Error Table 2

Even you can try with NOPI tables as staging, it can be faster and then load to target table .

Cheers,

Raja